How to Compile Multiple Excel workbooks in single excel file??

[Ganesh Lingayat]

Hi Everyone

i have around 25-30 excel files with same data Headers. this all files are regularly updated by different persons at different locations. all files are stored at server in single folder only.
i want to connect all this files to a my master file with additional data column with regular changes done automated in master.
what function should i use for this.

Thnaks

Ganesh

 

[Nightlytic]

The most efficient way would probably be power query:
https://support.office.com/en-us/ar...er-Query-94b8023c-2e66-4f6b-8c78-6a00041c90e4
The other is VBA... you will find a lot of tutorials and code for this with googling, but in the end this will be specific to your own project.

 

[Khalid NGO]

Hi,
You can also check this add in:
https://www.rondebruin.nl/win/addins/rdbmerge.htm

User friendly for merging multiple files into one, but this needs to be run every time you want to combine the files.

Regards,