Unique entries

[Todd Huttenstine]

Hey guys I have 2 workbooks. 800.xls and 900.xls. I have
a range of values on worksheets(1)in cells A1:A200 on
workbook 800.xls. Some values in this range may be the
same. What is the code that will look in this range
A1:A200 of worksheets(1) and list only the unique values
in range A1:A200 of worksheets(1) in workbook 900.xls?


Thank you

Todd Huttenstine

 

[Frank Kabel]

Hi
have a look at
http://www.cpearson.com/excel/duplicat.htm#InOneNotOther

 

[Todd Htutenstine]

Thanks but I am behind a firewall at work and cannot view
that page. Do you know of a vba code that will do this?

 

[Frank Kabel]

Hi Todd
can you explain yopur desired result with some example rows (plain text
please). Not fully sure what you want to compare with what

 

[Bernie Deitrick]

Todd,

Workbooks("800.xls").Worksheets(1).Range("A1:A200").AdvancedFilter _
Action:=xlFilterCopy, _
CopyToRange:=Workbooks("900.xls").Worksheets(1).Range("A1"), _
Unique:=True

HTH,
Bernie
MS Excel MVP