Filtering repeated names to get a list of unique names

Hi, really hoping some can help me with this. I have a very long list of names (many names in column A in attached file) and I need to filter through these names and list the unique names in column B. Would appreciate a macro for this. Any help is greatly appreciated.

Hi, if macro is not a must try use a simple excel function below:
1. copy col A, paste to col B
2. select col B, go to Data menu > remove duplicates
3. select the option "continue with the current selection" > click "remove duplicates" > OK

Thannsk Alvin, following your steps, I have recorded the macros as follows:

Columns("A:A").Select
Selection.Copy
Columns("B:B").Select
ActiveSheet.Paste
Application.CutCopyMode = False
ActiveSheet.Range("$B$1:$B$13").RemoveDuplicates Columns:=1, Header:=xlNo

The above works! Thanks!

Thank you for your feedback, you're welcome
ps: that's a smart way of you to record it



_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin