Notifications
Clear all
General Excel Questions & Answers
4
Posts
3
Users
0
Reactions
100
Views
Topic starter
Is there an easy way to combine multiple excel files (with 1 worksheet each) into one workbook.
example :
I have 30 workbooks with 1 sheet each....would like to combine them into 1 workbook with 30 worksheets.
Thanks
Posted : 08/06/2017 4:51 pm
Hi Rene
You can give this a try. You will need to change the path in the macro to where your files are located.
Hope this helps.
Sunny
Posted : 08/06/2017 8:46 pm
Topic starter
Thanks so much.....that worked perfectly !!
Posted : 09/06/2017 11:44 am
For the record: this also can be done 'by hand' of course with copy or moving the sheet to one file and place them in the order you want to......
Posted : 16/06/2017 4:59 pm
