#1
|
|||
|
|||
Matching records from different worksheets
Hi all, I'm trying to figure out how best to achieve the following.
I have records split across 2 worksheets, Data1 & Data2. I want to match the data from both worksheets according to a common field (ID) containing a reference that is unique to the complete record and output the result to Worksheet Data4. The records in Data1 & Data2 will not be in the same order. I need to do this for potentially large data sets. Ideally I would like to be able to type the worksheet name and range of both sets of source data into a message box asking where the fragmented records can be found. I've posted an example workbook containing Data1 & Data 2 worksheets with test data tables, Data3 the result that I want to achieve and a blank worksheet Data4 where I want to achieve it. Very grateful if anyone can help me here please. |
#2
|
|||
|
|||
In the past i would have done and index and match (and probably still would on most occasions) but as you said large data sets i thought i would try Power Query
I have only used PQ a couple of times but have a look at the attached and see if it was something like you were after - i am sure the headings can be changed easily enough and formatting etc There are plenty of video on Youtube on how to do this but i also find these guys very good https://www.myonlinetraininghub.com/...e-excel-sheets |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
When using a 'Master' template, if number of records change, subsequent records will not be read | MailMergeConfused | Mail Merge | 5 | 07-28-2016 05:07 PM |
Matching last in a list | salse | Excel | 3 | 06-08-2016 08:08 PM |
Record Matching | Excel | Excel | 13 | 08-21-2014 09:44 PM |
Advanced Filter - Copy matching records in two worksheets | morgantobin | Excel | 1 | 03-29-2013 03:58 AM |
Need To Compare Two Worksheets, Update Current Records And Insert New | David92595 | Excel | 1 | 07-20-2012 07:00 AM |