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) an...
excel
Macros and VBA
office 365
  • Rufus_Bertrand's avatar
    Rufus_Bertrand
    Jun 23, 2021
    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:)
HansVogelaar's avatar
HansVogelaar
MVP
Jun 23, 2021

Rufus_Bertrand 

From which sheet do you want to copy a row to Sheet3? From Sheet1 or from Sheet2?

Rufus_Bertrand's avatar
Rufus_Bertrand
Brass Contributor
Jun 23, 2021
HI Hans,

I want to return row from Sheet2.

thanks!

Resources