Register
Log In
Unanswered
Home
Xtreme Pivot Tables
October 22, 2015
Offline
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
See Answer
Dashboards
June 25, 2016
Offline
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
Answers Post
Xtreme Pivot Tables
October 22, 2015
Offline
Thanks so much.....that worked perfectly !!
Dashboards
Power BI
Power Query
April 21, 2015
Offline
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......
Most Users Ever Online: 57
Currently Online: Max Neumann
17 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Ajay Mukhi
Stephen Motte
Rodney Hoyle
michael pitre
Samantha Burleson
Krishnaa Kurugod
David McSwain
Shameem Nassiree
Alanna Henderson
Janel Oz
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
