Combining multiple Excel workbooks into a single Excel workbook
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
MR
5 - Atom
‎08-30-2021
12:51 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have numerous Excel workbooks in a single folder that I want to combine into a single Excel workbook. Each workbook only has 1 worksheet. Each tab, or worksheet, has a unique name (this seems to be source of my confusion). The schema is identical across all of the Excel workbooks. How do I combine these into a single Excel workbook?
Thanks!!
MR
Labels:
- Labels:
- Input
1 REPLY 1
Drussek
9 - Comet
‎08-30-2021
02:02 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @MR take a look at attached workflow.
It creates one output file with Sheets from every xlsx file in a choosen folder.
