Hi,
I have 6 tabs in my sheet. In column A of these sheets are parts codes/identifiers. I want a macro that will look in tabs 2 and 3 down column A for duplicates.
If two duplicates exist in the SAME sheet it should delete one of them (the whole row). If one or more duplicates in column A in tab 2 are also in tab 3 it should delete ALL duplicate rows in tab 2 and keep just one in tab 3.
I'd like this to happen separately with tabs 4, 5 & 6. So, any duplicates across these 3 tabs in column A it should delete the row THEN keep only the entry in the higher tab.
Example,
Bob is listed twice in column A of tab 4, 3 times in tab 5 and twice in tab 6. The macro would delete all entries in the lower tabs (4 & 5) and then delete the duplicate in tab 6 to leave just one unique entry across the 3 tabs in the highest tab number. I can post a sample workbook if it helps.