Merging data from different excel files into one worksheet

[sahjid]

Hi,

I am trying to merge data from a number of excel files (60+) into one spreadsheet. The header rows are the same, however, the number of records in each file is different.

Can someone please help with a VBA code that can copy data from each file and add them all to a single worksheet in a new file.

Thanks in advance.

 

[Alice Morland]

have you tried power query instead of VBA? It's what I'm using for these mergers.

 

[sahjid]

have you tried power query instead of VBA? It's what I'm using for these mergers.

Hi Alice, thanks for your reply. I have not used power query before. Can you please elaborate. Thanks.