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.
|