Hi

I have this macro that points out "MISSING" and "DUPLICATE". Its good but I have an issue where there is more than one entry the same on both worksheets. Although these are duplicate entries they are not as there are exact matching entries on both sheets. The defention of duplicate is if there is more than one entry on sheet called "WFD" and only one entry on sheet called "TAB"


Is there anyway you can add to this macro and look through the sheet called "sheet 3 " for entries marked DUPLICATE and then look through the tabs marked "TAB" and "WFD" again to see if there is more than one matching entry on BOTH sheets and if there is delete the entry from sheet 3?

Please Login or Register  to view this content.