Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-27-2020, 07:28 PM
LisaT LisaT is offline Merging a table from multiple files into one table in a single file Windows 10 Merging a table from multiple files into one table in a single file Office 2016
Novice
Merging a table from multiple files into one table in a single file
 
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
  #2  
Old 08-27-2020, 07:33 PM
LisaT LisaT is offline Merging a table from multiple files into one table in a single file Windows 10 Merging a table from multiple files into one table in a single file Office 2016
Novice
Merging a table from multiple files into one table in a single file
 
Join Date: Aug 2020
Location: Melbourne
Posts: 3
LisaT is on a distinguished road
Default

By the way, I would also like it to read from a variable number of files.
Reply With Quote
  #3  
Old 08-27-2020, 10:06 PM
LisaT LisaT is offline Merging a table from multiple files into one table in a single file Windows 10 Merging a table from multiple files into one table in a single file Office 2016
Novice
Merging a table from multiple files into one table in a single file
 
Join Date: Aug 2020
Location: Melbourne
Posts: 3
LisaT is on a distinguished road
Default

Also, there a multiple worksheets within each Excel file so it will need to reference the correct worksheet.
Reply With Quote
  #4  
Old 08-28-2020, 06:42 AM
Purfleet Purfleet is offline Merging a table from multiple files into one table in a single file Windows 10 Merging a table from multiple files into one table in a single file Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

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

Tags
merge, multi-files, table

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merging a table from multiple files into one table in a single file Merging multiple items to a table, Formatting orion23 Mail Merge 8 07-21-2018 11:41 PM
Merging a table from multiple files into one table in a single file Merging multiple excel records in to a single word doc? dns_to Mail Merge 1 10-20-2017 01:22 PM
Merging a table from multiple files into one table in a single file Merging Multiple Files by Name, Date abs004 Excel 1 03-02-2017 04:21 PM
Merging a table from multiple files into one table in a single file Combine Different Word files into one file and update Table of Content tejaspareek Word VBA 4 11-04-2014 05:50 AM
Merging Multiple Word files into One Stattovic Word 0 01-06-2010 07:19 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:10 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft