Delete both Original and duplicate rows

[Caraexcel]

Good Evening,

I have basic VBA skills. My worksheet that will have duplicate data inserted into it. Once inserted I need to delete the new duplicate row and the row it duplicated. The attachment is a copy of what the data looks like with the first tab showing what it will look like with inserted data and the second tab is what I want it to look like at the end. I will not need the deleted data again so it does not need to be on a new sheet, that is just for an example. The name of the tabs will also be different so I want to be able to run it on any worksheet. This is the code I am using to find and delete the duplicate but I can't get it to delete the original. I used "First, MI, Last, and DOB" because those are the ones that won't be duplicated where others will. This is a list of about 15,000 entries. There should never be an incident where there is triplicate data but I can't say for sure.

Thank you in advance,
Cara

Please Login or Register  to view this content.

[sktneer]

This code is not mine but try this to see if this works for you.

Please Login or Register  to view this content.

[Caraexcel]

Sktneer,

Thank you very much! It worked perfectly! I really appreciate your help. Still trying to understand why it worked, but it did.

Thank you,
Cara