title: Formula or Macro to divide long list (multiple columns) into separate lists based on criteria in one column
body: <p>I have a log list of data with the first two columns as potential identifiers, as shown in shortened form in the image at Flickr (noobie - can't post pictures):</p>
  
  <p><a href="http://farm8.staticflickr.com/7036/7114053281_30bf57300d.jpg" rel="nofollow">http://farm8.staticflickr.com/7036/7114053281_30bf57300d.jpg</a></p>
  
  <p>I have already sorted based on value Column B. I would like to be able to split this long set of data into separated lists of the four columns, with a single list containing one "Spot ID", like this:</p>
  
  <p><a href="http://farm9.staticflickr.com/8160/6967974902_7f84b57e46.jpg" rel="nofollow">http://farm9.staticflickr.com/8160/6967974902_7f84b57e46.jpg</a></p>
  
  <p>Column A "Frame #" is not critical, but I left it in since I wondered if it could be used to make the macro easier to run.</p>
  
  <p>I have to process a lot of data like this, so I want to understand how I can modify the macro to send the separate lists to different sheets, rather than different columns, for instance.</p>
  
  <p>In case you are wondering, the Frame # refers to a video micrograph frame, and the spot ID refers to a specific colloidal particle that was tracked. X Pos and Y Pos are X and Y coordinates, respectively.</p>
  
  <p>Any help is much appreciated.</p>
  
  <p>nan0guy</p>