You could use Advanced Filters to using Copy to another location. But this
has to be on the active sheet. It will give you the unique value list, when
you set the criteria to 'nothing'

Cheers
Nigel

"scrabtree" wrote in message
...
I need a code that will take all the unique entries in
column A Sheet 1 and list them in column 1 Sheet 2.