Merge 75 files

[Sriram Iyengar]

Hi Team,

How can I merge the data from 75 excel files into one single file. The column headers are the same & so are the data formats. It is however important to note that the 75 files will be updated on a daily basis

 

[vletm]

Sriram Iyengar
Have You used 'Search' from Chandoo.org?
If You've skipped that - then do it,
there are many solutions for merging too.

 

[AlanSidman]

Combine multiple Excel files using Power Query [Full example + download] » Power Query Case Studies

Say you want to combine multiple Excel files, but there is a twist. Each file has few tabs (worksheets) and you want to combine like for like, ie , all Sheet1s to one dataset, all Sheet2s to another dataset... Now what? Simple - use Power Query.

chandoo.org