anyone know how to help with complicated comparison needed

[mlopez60120]

Team I need some help.

First Step The file has 3 TAB. I need to compare the data in the Master tab to the RPT TAB and identify what matches by color in the Master TAB and what is in RPT that is not in MASTER identify by color in RPT tab.

Second Step Master tab to the NEW TAB and identify what matches by color (different from First Step) in the Master TAB and what is in NEW that is not in MASTER identify by color in NEW tab.

File is attached

[David A Coop]

Are the lists the same on the three tabs? They appear to be in different formats, so matching will be very difficult without some rules.

Do you have any?

Why do you mention color? I can't see it mentioned.

Regards,

David