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
Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
ExcelToDAX
Board Regular
- Joined
- Feb 9, 2023
- Messages
- 235
- 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
- 235
- Office Version
- 365
- Platform
- Windows
Power Query does create a table
Upvote
0
Similar threads
- Replies
- 24
- Views
- 551
- Replies
- 3
- Views
- 338
- Replies
- 3
- Views
- 629
- Replies
- 5
- Views
- 177
