-
Solved: How can I copy sheet 1 from multiple spreadsheets to one new workbook?
Hi All,
I have c. 200 spreadsheets in a folder, I need to quickly copy sheet 1 of each of these and paste them into one workbook. I would also like to name each sheet in the new workbook as the last 9 characters of the original filename.
Can anyway help with an easy way to do this.
Thanks,
Marshybid
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