Hello all,

I hope everyone is well and safe.

I just joined this forum as I need to merge data from multiple files into a single file for work ASAP. I understand that there is the mail merge function but the out of the box function does not read from multiple files. I did see a thread on this forum where INCLUDETEXT was suggested. I tried it but mustn't have used it correctly. I think I will need basic instructions as I am not a proficient at writing scripts.

In a nutshell, I have multiple Excel files with each containing a table with the same column headings.



I would like to consolidate, or merge, them into a "master" Excel file under the same column headings. Ideally the master file is in Excel, if not, one big table in Word document will do.

I'd like to have the consolidated table sorted by one of the columns after all the data has been copied across.

row 1 Column A, B, C, D from file 1
row 2 Column A, B, C, D from file 1
row 1 Column A, B, C, D from file 2
row 2 Column A, B, C, D from file 2
...
sort by column B

Thank you in advance.

Regards,
Lisa

By the way, I would also like it to read from a variable number of files.

Also, there a multiple worksheets within each Excel file so it will need to reference the correct worksheet.

Have you had a look at power query?


https://www.myonlinetraininghub.com/...-from-a-folder


This can combine files really easily with very little time invested.


The alternative is VBA, but that will take a bit more planning and anm understanding of coding