title: VBA Macro that returns a list of items that meet criteria
body: <h2>I am trying to create a UserForm in Excel 2010/2013 that will look through a list of items and return a complete list based on a number I provide.</h2>
  
  <p>Here's what the list would look like: <strong><a href="http://i.imgur.com/doNABFP.jpg" rel="nofollow">See Example</a></strong> (image hosted on Imgur)</p>
  
  <p>A Here's a snippit in case the image won't load...  </p>
  
  <p>Location ----- Title ----- Days Past<br>
  A2: 0001 | B2: Movie 1 | C2: 32<br>
  A3: 0001 | B3: Movie 2 | C3: 18<br>
  A4: 0001 | B4: Movie 3 | C4: 10<br>
  A5: 0004 | B5: Movie 1 | C5: 32<br>
  A6: 0007 | B6: Movie 1 | C6: 32<br>
  A7: 0007 | B7: Movie 2 | C7: 18<br>
  A8: 0009 | B8: Movie 1 | C8: 32<br>
  A9: 0014 | B9: Movie 1 | C9: 32  </p>
  
  <p>I have a userform that will return the first item in the list, but not the complete list. Ideally I would like to stay away from using a list box, mainly because the goal is to be able to copy the items in the full list. </p>
  
  <p>I have tried the Index() formula but I don't know how to transfer that to work in VBA.<br>
  Any help you have would be great! </p>