Merging all data between two sheets into a third one without duplicates or rows or columns

Purfleet · #4 08-25-2020, 01:32 PM

You have 2 options as far as i know, but both will require some setup work.

1) VBA.
A macro could easily open an extract and combine data into 1 report with index and match, but you would need to know the file path and name and then be able to code it. not particularly hard but if you have never used VBA you would have a fairly steep learning curve

2) Power Query
As I said before I don’t know a lot about power query but from what i have read you can import extracts from a folder and hit refresh and the combining will be done - you would obviously need to do it once and set it up but then I should be a fairly quick refresh.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Transpose multiple data form rows in columns matched with a key	Alex1s85	Excel	6	06-24-2020 07:08 AM
How to Loop through rows and Columns to Offset Data	Josh1012	Excel Programming	4	09-06-2018 03:20 AM
Insert rows when column A data changes then shade and autosum blanks in columns E to I	kgoosen	Excel Programming	0	08-30-2017 04:45 AM
[EXCEL 2010] Merging data from three different sheets	bremen22	Excel	1	08-20-2013 10:00 AM
Merging three columns of data	jdjette	Excel	7	03-02-2012 04:48 PM