Hi
just use 'Data - Filter - Advanced Filter' and check 'Unique entries'

If you need this in VBA simply record a macro while doing this manually


--
Regards
Frank Kabel
Frankfurt, Germany


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