Forum Discussion
Rufus_Bertrand
Jun 23, 2021Brass Contributor
Excel help pulling data to a new sheet by comparing data for matches in 2 other work sheets
Hi all,
I have a workbook with 2 worksheets, Sheet1 and Sheet2.
I need to lookup values in Sheet1, Col E (Employee-E) and Col H (Ded-Code-E) and find matches in Sheet2, Col C (EdmEmployee) and Col D (EdmDedCode). If I find a match, I want to copy the entire row over to new Sheet3.
I've uploaded test spreadsheet with a few rows for reference.
I have a VB macro in there, but don't know how to edit it to do what I want. Pretty new to Excel and macros, so I'm a bit over my head here!
Thanks in advance!!
Have a great day:)
Rufus
- Great!
I'll check out the links you provided to learn more about Dictionary object usage.
thanks so much for your help Hans!!
Have a great day:)
12 Replies
From which sheet do you want to copy a row to Sheet3? From Sheet1 or from Sheet2?
- Rufus_BertrandBrass ContributorHI Hans,
I want to return row from Sheet2.
thanks!I;ll look at it later if nobody else does.