Why do you copy column A to sheet2 column A? Can't you just filter uniques
directly to A1 of sheet2 from column A of sheet1?

Manually, insert sheet2
select A1
then do the data|filter|advanced filter
and point at the ranges you want (I'd just use A1 of sheet2 for the destination
range).

I recorded a macro when I did it manually and got this:

Sheets("Sheet1").Columns("A:A").AdvancedFilter Action:=xlFilterCopy, _
CopyToRange:=Range("A1"), Unique:=True

I'd be more specific and qualify that copytorange:

Sheets("Sheet1").Columns("A:A").AdvancedFilter Action:=xlFilterCopy, _
CopyToRange:=sheets("sheet2")Range("A1"), Unique:=True



jay wrote:

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

--

Dave Peterson