Delete duplicate rows

[garden_gnome]

Hello All,
Earlier today TMShucks had provided me with the following code. (Thank you again TMS for your help!)
This code compares A1 to B1 and if equal, copies A1&B1 to Sheet2 and then deletes row1 from Sheet1.
It also comes back with a handy msg box that tells me how many duplicates were removed, and how many unique records remain.

Please Login or Register  to view this content.

I now need to be able to adapt this code to compare rows. Example, does A1 & B1 = A2 & B2. If so, copy row 2 to Sheet2 then delete row 2 from Sheet1.
I also need to have this work from TOP to BOTTOM as the the first line will contain information that I want to keep.
The current code (above) works from the bottom up. (would also like to get that working from TOP down if possible)
Since I have no idea how the above code works (was a complete re-write of my code) I can not begin to try anything to get this to work. I already tried getting it to run from top down and failed miserably.

Here is an example workbook to work from that includes the above code, and my original code that worked from TOP to bottom. (Very different code)
Also does not contain all columns as that has sensitive data. :-)
Del_Dup Test List.xls

Any more help would be greatly appreciated!

Thanks Again!

[arlu1201]

Just wanted to clarify - I see data in this format -

MFG_NAME MFG_ID

10 MIL 10MIL

10MIL 10MIL

I would consider this as non-duplicate. Would you consider this as a duplicate?

[garden_gnome]

Just wanted to clarify - I see data in this format -

MFG_NAME MFG_ID

10 MIL 10MIL

10MIL 10MIL

I would consider this as non-duplicate. Would you consider this as a duplicate?

Correct... That is a NON duplicate.
Actually the duplicate 10MIL side-by-side will have been deleted by the original code that compare A1-B1.

[arlu1201]

Ok, so ideally you will be running that first bit of code to compare A1-B1. And then the 2nd code to compare A1&B1 with A2&B2. Right?

[garden_gnome]

Ok, so ideally you will be running that first bit of code to compare A1-B1. And then the 2nd code to compare A1&B1 with A2&B2. Right?

That is correct!

[arlu1201]

Use this code - I ran it myself and didnt find any duplicates in the sample data that you provided. This code will cut paste the 2nd line of each pair that is duplicate to the 2nd sheet and then once all the rows are done, it will sort the page, so that the blanks go off. (Blanks derived from the cut paste).

Please Login or Register  to view this content.