can you provide any macro or VBA for excel that will merge mutiple excel files of selected folder. The folder has many files with unique sheet names in each files. it will allow user to select folder and it will merge all files into one file. Further it will merge file as per order of file as per it is available in the selcted folder. can any one please help.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
MERGE EXCEL FILES
- Thread starter DHAWAL
- Start date
Excel Facts
Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
ExcelToDAX
Board Regular
- Joined
- Feb 9, 2023
- Messages
- 246
- Office Version
- 365
- Platform
- Windows
Have you thought about using Power Query get files in a folder?
Upvote
0
No, because it requires conversion into table, instead merge file macro will be betterHave you thought about using Power Query get files in a folder?
Upvote
0
ExcelToDAX
Board Regular
- Joined
- Feb 9, 2023
- Messages
- 246
- Office Version
- 365
- Platform
- Windows
Power Query does create a table
Upvote
0
Similar threads
- Replies
- 24
- Views
- 609
- Replies
- 3
- Views
- 360
- Replies
- 3
- Views
- 649
- Replies
- 5
- Views
- 212
