Loop Copy and paste multiple ranges from multiple workbooks

Hi All,

I have a macro that is looping through all workbooks in a folder to collate certain data into a master workbook.

What I am finding though is that when the macro loops to the next workbook it is pasting not at the bottom of the last workbooks data but only under the first row of 19 rows.


I have attached the workbook (macro is called January), code below.

Please Login or Register  to view this content.

How do I make it paste to the bottom each time?

Thanks,
Brendan

Hi leelnich,

thanks for the reply. Just tried this and all it did was add a 19 row gap between the pasted data and the existing data:

Capture.JPG

Thanks again,

Sorry but I am not really too savvy with vba and just copied this code so I am not sure how to do what you said. I have place it like this but am getting an error:

Please Login or Register  to view this content.