copy/paste from multiple files in a folder to single workbook

[HXIO]

Hi all,

I came across this code and edit it to try and copying all files in the folder of the first sheet from row A2 to the last row in column A to another workbook.

The pasting will be from row A2 onward in the master workbook.

But can't seem to get it to work.

Please Login or Register  to view this content.

[Greg M]

Hi there,

See if the following version of your code does what you need:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

[Marc L]

(removed as too late)

[HXIO]

@Greg M

Thanks for the help ^^

[Greg M]

Hi again,

Many thanks for your very prompt feedback and also for the Reputation increase - much appreciated!

You're welcome - glad I was able to help.

Best regards,

Greg M