I have a list that can continously grow of peoples names in A and the peoples
name can appear mulitiple times throughout the list. I would like to run a
macro once a week that would create a new list on another sheet of each
persons name that appears on the long list, but just list them once... I
have tried different code, and know it is easy, but I am confused. I
appreciate your assistance.

List A List B
Bob Bob
Bob Wayne
Wayne
Bob
Wayne
--
Jeff