value interpretation

S

solo_razor

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
extracting unique values with a formula or with vba 1
Creating a list in Excel for a matching criteria 4
modified pivot table using a macro 2
How to get a value from 1 table to a 2nd. 15
Sheet to sheet code Type Mismatch 6
Array with many cells from a row but not in order or together 11
Excel does not accept text format! 0

Top