|
|
#2
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/ 
|
|
|
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 |
Windows 10 
Office 2019
Threaded Mode