-
Copy multiple workbooks to specific sheets
Hi all,
I am having the same problem. I want to copy sheet1 from 20 closed workbooks.
I have the path in column A.
The sheets (of closed workbooks) need to be copied to this file in a specific sheet name that is already created.
The Sheet name is in Column B.
Is thiss possible?
It contains 20+ files with only ±20 rows of text.
Thank you
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules