Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-16-2021, 05:24 AM
CuriousG CuriousG is offline Matching records from different worksheets Windows 10 Matching records from different worksheets Office 2016
Novice
Matching records from different worksheets
 
Join Date: Jan 2021
Posts: 20
CuriousG is on a distinguished road
Default 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.
Attached Files
File Type: xlsx Test Data.xlsx (17.9 KB, 7 views)
Reply With Quote
  #2  
Old 06-16-2021, 01:16 PM
Purfleet Purfleet is offline Matching records from different worksheets Windows 10 Matching records from different worksheets Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

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
Attached Files
File Type: xlsx Test Data_AR12.xlsx (19.8 KB, 6 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Matching records from different worksheets 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 records from different worksheets Matching last in a list salse Excel 3 06-08-2016 08:08 PM
Matching records from different worksheets Record Matching Excel Excel 13 08-21-2014 09:44 PM
Matching records from different worksheets 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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:30 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft