Auto create column with unique values
 

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

Auto create column with unique values
 

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

Auto create column with unique values
 

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

"Bernd P" wrote:

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

Auto create column with unique values
 

www.mysmartnumber.com/sampledatafile.zip

"ANDNAND" wrote:

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

"Bernd P" wrote:

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