Copy / paste original reocrds only

[clive2002]

Anyone now how to copy a range that contains some duplicate records and only paste original records.

I have a range of names, some repeated and i want to creat a copy in another sheet only showing each name once.

I want to use VBA without a pivot table?

 

[shades]

Howdy. You can use the Advanced filter, and click the "unique records only" box. You can do that using VBA as well.
________
Charles e. sorensen