Hi

2. When I record the process in a macro, it never works ?

If you run this do you have problems then

Sub test()
Sheets("Sheet2").Columns(1).AdvancedFilter _
Action:=xlFilterCopy, _
CopyToRange:=Sheets("Sheet2").Range("B1"), Unique:=True
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"jay" wrote in message ...

Hi,

I'm trying to resolve a list of names into a new list of 'unique'
names.

On sheet_1 I have a list of names in a column, some appear several
times.

I copy this column from sheet_1, to sheet_2 column "A".

1. I then select - Data - Filter - Advanced Filter - (Copy to
another location) - (Unique Records Only).
2. For the "List Range" I select column "A" of sheet_2 which resolves
to "$A:$A".
3. For the "Copy To:" I select column "B" of sheet_2 which resolve to
"$B:$B".

Problem:
1. Sometimes the above just does not work, resulting in no copy to:
column "B", yet sometimes it does (using the exact same data).
2. When I record the process in a macro, it never works ?

Any solutions ?


--
jay
------------------------------------------------------------------------
jay's Profile: http://www.excelforum.com/member.php...fo&userid=2377
View this thread: http://www.excelforum.com/showthread...hreadid=515000