Adjust a copy macro from another workbook to print the name of the workbook as well

Hey guys,

I have this nice macro that copies data from another workbook. I want to make it to also add the filename of the workbook (for example data.xlsx) it copies the data from, in a cell on the actual workbook (for example on sheet "Combined", Cell A10). What should I add to my macro?

Please Login or Register  to view this content.

Thank you very much in advance!

Maybe:

Please Login or Register  to view this content.

That's perfect, thank you John!

You're welcome. Glad to help out and thanks for the feedback.