How may I combine separate workbooks

Alansidman · #1 06-02-2019, 01:00 PM

You could load each of the sheets into Power Query providing that they are all arranged exactly the same. Once in PQ, you could append each to the other.

Here is a tutorial

https://www.powerquery.training/port...ta-from-files/

whitland · #2 06-03-2019, 02:37 AM

Thank you for your reply to my query. I will try Power Query as you suggest. Have to say that it does look somewhat complicated so may take some serious thought processes!!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Possible to combine 3 different workbooks?	markg2	Excel	5	11-14-2016 12:36 AM
How do I separate an address into separate cells	Austcart	Excel	2	01-18-2015 03:48 PM
Office 2008 workbooks into Office 2011 workbooks	nfotx	Excel	0	12-07-2014 04:22 PM
Can I use the filter function to separate letters into separate files?	drhauser	Mail Merge	2	12-14-2011 02:18 PM
Any easy way to separate a Word document into separate files?	SamHelm	Word	0	08-21-2010 05:29 AM