Results 1 to 1 of 1

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

  1. #1

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



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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...
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •