Delete matching records but some duplicated.

[tweacle]

Hi

I dont know where to start on this one.

I have a workbook with 2 sheets and data in columns A-D.What im trying to do is when there is a match exactly the same on both sheets I need the row deleting from sheets 1 & 2. The issue I have is that sometimes there is 1 row of data on sheet 1 and 2 or 3 rows with the same data in sheet 2 and I dont need both rows of data deleting in sheet 2 and only 1 as there is only 1 entry on sheet 1.

The data will always be in columns A-D but spread over different rows over the worksheet. I.E lets say sheet 1 row 99 matches data in sheet 3 row 400 then I need both rows deleting.

Is there anyway I can do this