Macro to Copy / Paste data from one sheet to a new sheet

[maggiej0531]

Hi all --

I have a csv file with data from the Twitter API. Each row has an uneven number of data points so the two data points I am interested in -- the tweet, labeled "text" -- and the coordinate --labeled "coordinates:"-- do not fall into straight columns. I would like to line up the columns so that I can sort by coordinates (collecting all similar geographies).

I tried recording a macro to do this by searching for "text," copying into a new sheet, then searching for "coordinates" and copying into the new sheet. I'm stuck now, though, because I don't know how to loop this macro to search in the next line, paste in the new line of the next sheet, then do the same task to the end of the sheet. An added complication is that after the initial coordinate data point, there can sometimes be additional coordinate data points later in any given row. Any help would be very helpful!!!

Thanks in advance.

 

[dermie_72]

have you thought about using filters to identify all of the items that meet your criteria, then copying and pasting without looping.
You can search vba autofilters to copy and paste which will show you how.