Help Filtering

  • Thread starter Thread starter nrage21
  • Start date Start date
N

nrage21

As usual another frustrating problem.

I have the following...
A workbook with 2 sheets. I have designated a column in Sheet1 fo
names which is linked to a column in Sheet2 (the link appears like thi
on the cell ='sheet1'!$C$R). As names are entered both columns increas
of course, this is not a problem.

I want to filter the column in sheet2 for "unique records" becaus
there are several duplicates... this is where is gets frustrating...

I click on the "record macro" button select column in sheet2, go to th
menu: Data => Filter => Advanced Filter, Filter Range is fine, I chec
mark the "copy to" and "unique record" boxes and select the new rang
to be copied to, WHEN I click OK, I get the following message...

"The extract range has a missing or illegal field name"

I tried menu: Name=> Define and deleted any names there
I deleted the entire column in sheet2 and did it over in anothe
column
I redid the links
I read all posts refering to duplicates and...

nothing so far has worked, so once again I come to the pros. Pleas
help!

Why does this occur? Can I be provided some code? or another solution?

TIA
- Larry -
VBA Amateu
 
Larry,

Try this code, to extract unique values from column A, for a table starting
in cell A1:

Range("A1", Range("A1").End(xlDown)).AdvancedFilter _
Action:=xlFilterCopy, _
CopyToRange:=Range("A65536").End(xlUp)(3), _
Unique:=True

HTH,
Bernie
MS Excel MVP
 
Back
Top