Forum Discussion

Rufus_Bertrand's avatar
Rufus_Bertrand
Brass Contributor
Jun 23, 2021
Solved

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:)

Resources