View Single Post
 
Old 08-27-2020, 07:28 PM
LisaT LisaT is offline Windows 10 Office 2016
Novice
 
Join Date: Aug 2020
Location: Melbourne
Posts: 3
LisaT is on a distinguished road
Default Merging a table from multiple files into one table in a single file

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
Reply With Quote