I have a macro that copies row data from one sheet to a master spreadsheet
(thanks again to Tom and Ron for this). Now I would like to create another
macro to copy additional non sequential row data but I would like this data
to be copied to the original master spreadsheet created above. What code
would I add to look at the first empty row in that master spreadsheet and
copy this new data?

My original macro is in the post Macro Revision needed from yesterday. I
was trying to modify that macro to accomplish everything at once but have
been unsuccessful. This is the only other alternative I could think of to
accomplish getting the data on one master spreadsheet versus creating
multilple spreadsheets and then having to consolidate. I received great
feedback on how to copy rows that I selected but I'm not sure how to then
loop through the rest of the spreadsheet.

Thanks in advance.