Combine data from different excel files

[KIM Chanthan]

Hi,

Do you have any VBA code to consolidate data from different excel files into one file?
Let say, I have 3 excel files and I want to combine all these data into one MasterFile.
Note: All header of all files are the same.

Thanks,
Chanthan


▬▬▬▬▬▬▬▬▬ Mod edit : thread moved to appropriate forum !

​

 

[vletm]

KIM Chanthan
... as with same case ... why did You duplicated it?
Anyway, You should write that
You have hundreds of files to combine to one 'Master file' .. not just three files!

 

[Marc L]

Do you have any VBA code to consolidate data from different excel files into one file?

▬▬▬▬▬▬ Mod edit : thread moved to appropriate forum !

Hi !

A must read : Consolidate data from different excel files (VBA) …
​