I remove duplicates by sorting on a key field and then subtotal and copy to a new datasheet ..... its not nice.

I could also use a pivot table for duplicate fields.

But in this case I have 2 requirements.
1. I need to remove any duplicate rows.
2. I need a macro to do it.

I think it should build a new worksheet.

Got any tricks?