Auto create column with unique values

[ANDNAND]

Dear All

I have the following data:

Sheet1
Columns: A=STATUS, C=GROUP, D=FIRST NAME, E=LAST NAME
STATUS=1,2,3 the rest are text and several people can belong to the same GROUP

I would like the following automation:

On Sheet2, Sheet3, Sheet4, I would like column A to autorefresh with unique
values for GROUP&1 sorted by 1st-STATUS and 2nd-LAST NAME

Thank you

 

[Bernd P]

Hello,

I suggest to take the more complex example from
http://www.sulprobil.com/html/sorting.html

Let me know if you need more info to adapt it to your needs.

Regards,
Bernd

 

[ANDNAND]

Thank you for your help, but is not exactly what I was looking for. I need
vba to do the following:

www.mysmartnumber.com/sampledatafile.xlsx

Please help, thank you

 

[ANDNAND]

www.mysmartnumber.com/sampledatafile.zip

Thank you for your help, but is not exactly what I was looking for. I need
vba to do the following:

www.mysmartnumber.com/sampledatafile.xlsx

Please help, thank you