VBA to only copy unique records from a filter

Ok I know something like this can be done with code like this:
Columns("X:X").AdvancedFilter Action:=xlFilterInPlace, Unique:=True

However the sisuation is slightly more complicated.
So I have a data sheet in which, lets say, column Y holds project names.
In column X there a names of persons who lead the project.

So now I wanted to make a validation in a given cell where a user can choose a project name.
What the macro then should do is filter the list on chosen project.
So far so good, but next step would be that he copies the column with names to a certain position so I then can have the macro create a validation on that list of names.

Still so far this works BUT if a name occurs multiple times I also get the name multiple times in my validation drop-down list.
And that is ofcourse something I do not want.
Hence my question to only get the unique records when he pastes the name column to the position were he should make the validation.

You can use the Collection, Code below is well commented. See if you can work with it. Modify to your needs.

Please Login or Register  to view this content.

Thanks for this Mike!
However this would I think mean rebuilding my macro and whas hoping for a bit simpler and small solution.
Ofcourse....IF this is possible.....

Can you upload your macro or workbook. It will be easier to see what is going on.

@rpinxt

Need to use code tags when posting codes to the forum. Looking at your code I think it will be easier if you can upload the workbook

sorry about that, fixed that now. However uploading the entire workbook will not be possible as the file contains classified info whitch I can not throw over the www...sorry.
But this is the entire macro for the part that I want.
Only other thing is a list with data about project and a column in which the user per project is defined

---------- Post added at 04:08 PM ---------- Previous post was at 03:56 PM ----------

Anyway...I just found out a method that suites my purpose.
With help of the remove duplicate function in excel 2007 (should have known that option sooner....)
So this small piece of code fixed my problem:

Please Login or Register  to view this content.

I understand, see if this will work. I havent tested but I think will work for you.

Please Login or Register  to view this content.