Hi,

I have a worksheet called Download with 55000 rows of data in it.

In column H I have a 13 digit number.

In column I have a Customer Name.

I need to do two things.

On the Dowload Sheet where the Customer Name In Column I is Customer 1 for example, I want to copy all those rows to a sheet called De Dupe.

When the data is on the De Dupe Sheet I need to remove any Duplicated numbers in Column H so that I am left with a clean list for Customer 1 of unique numbers in column H.

Could someone provide a macro that could do this please?

Many thanks