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

Hi Jeff,

Use the Advanced Filter feature and specify Unique values.

If you want to automate this, turn on the macro recorder while you run the
operations manually,

To extract the filtered data to another sheet, it is necessary to run the
filter from the destination sheet



---
Regards,
Norman



"Jeff" wrote in message
...
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