hello,

I want to look for values in a column and then copy those values in
another sheet.
example
if column d has 5 different value's i want to isolate these values and
copy those into another sheet.

d
paul
paul
john
paul
erik
jacob
jacob
paul
erik
nick
nick

now in the sheet2 the output should be
paul
john
erik
jacob
nick

Regards,
Niek


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/