removing duplicate rows

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?

Hi,
have a look at this solution

HTH

HTH,
This is perfect.

Thanks a bunch.

Thx for the feedback