MERGE EXCEL FILES

[DHAWAL]

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.

 

[ExcelToDAX]

Have you thought about using Power Query get files in a folder?

 

[DHAWAL]

Have you thought about using Power Query get files in a folder?

No, because it requires conversion into table, instead merge file macro will be better

 

[ExcelToDAX]

Power Query does create a table