View Single Post
  #1   Report Post  
John
 
Posts: n/a
Default Remove data from certain rows and place in new row or spreadsheet

I have a long list of data, approximately 5000+ rows. I also have a second
list of data that was derived from the first list by an outside source. I
want to take the 2nd list and bump it up to the 1st list and tell excel to
cut the data from that row and place it in another spreadsheet ideally, or
another area.