Hi
I have a workbook that im trying to delete matching entries but there may be occasions when there are duplicated entries.
What im trying to do is if in sheet 1 exactly the same data is in sheet 2 then I need both entries deleted from both sheets. The issue I have is that sometimes there will be duplicated entries in either sheet 1 or 2 and then I only need 1 entry deleted.
I.E say in sheet 1 there is one entry with data in columns A-D and there 2 entries the same in sheet 2 then I only need one entry in sheet 2 deleting. There may be the same the other way round where there 2 entries in sheet 1 but not sheet 2 and again I need just one deleting from sheet 1.
The data will be spread all over the workbook as in rows will not match on sheets 1 & 2 per row. Data poss in row 99 in sheet 1 may be in row 9999 in sheet 2 but if they match as per instructions above I need them deleting.
Attached is a workbook that I have started doing.
Any ideas as im very very new to macros
Thanks in advance
Bookmarks