title: VBA looping a file for every item in an array
body: <p>Excel VBA
  I will try my best to have this make sense.</p>
  
  <p>I have set my array for 29 items (equipment ID T0001-T0028).</p>
  
  <p>Essentially I have a report that has maintenance write-ups for these pieces of equipment.  I am trying to create a loop that will go through the file and find each time the equid ID is listed and then i will use the left/right/mid functions to extract data from the file.  However each equip ID will be listed multiple times so they way i am picturing this happening is for equip id T0001 the procedure will go through the entire file finding and extracting each time "T0001" is listed and then go to "T0002" and go through the entire file and so...</p>
  
  <p>I know it will be a loop of some sort but I am so confused on whether to loop the file or loop the array.  Can anyone help. </p>
  
  <pre><code>Sub EquipArray()
  Dim sampleArr() As Variant
  Dim i As Integer
  Dim rng As Range, cell As Range
  
  i = 1
  Set rng = Range("A2:A29")
  
  sampleArr = rng
  
  
  End Sub
  </code></pre>