Copy only range of columns from multiple worksheets to a summary worsheet

[fakafan]

Hi there

I found this code which copied data from multiple source worksheets into a single summary worksheets and this works perfectly for what i need but i need to update it to only copy columns A:H from the source worksheets, and not every row that has data in it.

Can anyone help me and tell me how i only get columns A:H from the source worksheets to copy to my summary sheet please?

Here is the code i found:

[Trebor76]

Hi fakafan,

See if commenting out this line of code (so you still have it if needed)...

Please Login or Register  to view this content.

...and using this instead does the job:

Please Login or Register  to view this content.

Regards,

Robert

[fakafan]

Hi Robert

Thanks for this. This worked perfectly.

[Trebor76]

Thanks for letting us know and for marking the thread as solved