Merging a table from multiple files into one table in a single file

		Microsoft Office Forums > Microsoft Excel > Excel
Merging a table from multiple files into one table in a single file

FAQ

Thread Tools

Display Modes

08-28-2020, 06:42 AM

Purfleet

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

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

Tags

merge, multi-files, table

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Merging multiple items to a table, Formatting	orion23	Mail Merge	8	07-21-2018 11:41 PM
Merging multiple excel records in to a single word doc?	dns_to	Mail Merge	1	10-20-2017 01:22 PM
Merging Multiple Files by Name, Date	abs004	Excel	1	03-02-2017 04:21 PM
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 05:29 AM.