VB Code to create a Unique Employee List

Hello:

Please refer to attached file, Sheet1

Column A thru J have Names of the employees
in store name listed in Row1

I need VB Code ti create a Unique list
of employees from these stores and paste in
sheet2 at cell A2


Let me know if you have any questions.
Thanks.

R

Hi rmomin,

Can you manually show us few samples of expected results in sheet2 ?

Hello:

Pls see attached.
Basically all Column Data in Sheet2 and sort out Unique.

R

Hello nankw83:

Thanks it works

R