Problem with Macro to Copy Data Rows

Hi there,

I've used the following macro to copy data from templates people fill out and paste into a master file.

Please Login or Register  to view this content.

The data starts from row 5 and I used column D to decide which rows to copy and paste

It works fine for spreadsheets that have 2 or more rows filled out. However, it doesn't seem to work for some spreadsheets that have 1 row of data only. Is there anything I can do to make this work for spreadsheets with 1 row of data?

Thanks in advance for your help

Hello zenjah,

Please could you provide us with your full code in this instance?

Hi Zenjah

Try this:

Please Login or Register  to view this content.

Hi Mike
Glad I could help. Please mark thread as solved and be so kind and add to reputation....lick star to left of post....