If Cell is NOT empty then Copy entire row to next spreadsheet

[legnak]

Hello,

After googling my question, I have found some answers, but I'm not really understanding how to use the macro or visual basic editor so, I need a little bit more in depth help.

What I am doing:

I have a sheet called "Price List" where there are 1000+ rows and columns go all the way to AC.

If A2 is blank (A1 has my header) then I want to to skip to the next row, if that row is blank then i want it to skip to the next etc, until it finds a row that has some data in it. When the row with data is found then I want it to copy that entire row into the spread sheet called, "Upload List" starting at A2 (because A1 is my header). I want it to check all the rows and copy them all over, while leaving the original spreadsheet in tact and unchanged.

So, if this requires a macro could you please tell me specifically how to copy and paste it over?

Thank you! (I'm on a mac if that changes anything)

[Kevin#]

Try this.
To run in attached workbook {ctrl} + t
(I am not on a Mac, so hope it's the same!)

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Another:

Please Login or Register  to view this content.

[legnak]

Try this.
To run in attached workbook {ctrl} + t
(I am not on a Mac, so hope it's the same!)

Please Login or Register  to view this content.

Thank you so much this worked perfectly.

[Kevin#]

You are welcome. Thanks for the reps.