Hi everybody,
I need an advice to how I in the easiest way can merge around 130-140 Excel files together into one large spreadsheet.
All the spreadsheets have the same column header. There are about 1000 rows and 800 columns in each spreadsheet.
I have been thinking about doing this manually, but I hope one of you have a good advice to how I can do this automatically?
Thank you in advance.
- Peter Andrews
Hi, Peter Andrews,
maybe have a look at Merge data from all workbooks in a folder or RDBMerge, Excel Merge Add-in for Excel for Windows or WBs to Sheets for some information or code to do this.
Ciao,
Holger
Last edited by JBeaucaire; 12-27-2019 at 10:06 PM.
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Hi Holger,
Thank you very much for this!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks