Using VBA: I have a list with multiple entries.Need to reduce down to unique entries

i have a list of names.........there are multiple names in the list.
I need to generate a "unique" list of names using VBA........

any ideas?

welchs101,

Something like this?

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

that will work! thanks!

question:

Using your suggestion from before i was able to get the "filered list". I can even copy the filtered list to a "new" destination. Which i like.

Here is some code (keep in mind i have not made it as variable ....i hard coded the range for simplicity)

Please Login or Register  to view this content.

What i want is the filtered list to go to col B. Which the above does do. However, i want the filtered list to start in B2 and not to put a col header...........anyway to do this?

welchs101,

Give this a try:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

also, is there a way to copy the contents to another workbook and sheet?

sorry to keep adding things to the list.

thanks for your help.

also, why do you do the clear statement at the end? just curious.

using what you gave me and some of my own code........here is what i have and it seems to work

Please Login or Register  to view this content.

again, just wondering about the clear statement. can you tell me why you did this?

thanks alot ..............you really helped.

welchs101,

again, just wondering about the clear statement. can you tell me why you did this?

...

i want the filtered list to start in B2 and not to put a col header...........anyway to do this?

I put the clearcontents line in to delete the column header

~tigeravatar