Macro for compare two sheets based on sheet3 reference data of sheet1

toravietl

New member
Joined
Mar 7, 2014
Messages
7
Reaction score
0
Points
0
Hi ,

I have attached one Excel sheet.Need to compare sheet1 and sheet2 data based on sheet3 data.Bcz sheet1 having old empid but sheet2 having new employee ids.If you compare these sheets automatically it mismatch.But we can use sheet1 empid with sheet3 reference data then compare sheet2.If corresponding empid not present in sheet3 then comapare those records with sheet2 normally.

Any one guide me onthis...
 

Attachments

  • Book1.xlsx
    8.6 KB · Views: 30
Top