riniheijnen
09-03-2012, 12:31 PM
I have a range of 10 columns and 10 rows.
row 1 adam
row 2 benny
row 3 alex
row 4 ann
row 5 chris
row 6 duncan
row 7 arlene
row 8 ed
row 9 ashley
row 10 nick
I would like to sort the rang as follows:
row 1 adam
row 2 alex
row 3 ann
row 4 arlene
row 5 ashley
row 6 benny
row 7 chris
row 8 duncan
row 9 ed
row 10 nick
Does anyone heve a clue to have this done because I have been trying but did't succeed yet in finding the correct code.
Regards
Rini
row 1 adam
row 2 benny
row 3 alex
row 4 ann
row 5 chris
row 6 duncan
row 7 arlene
row 8 ed
row 9 ashley
row 10 nick
I would like to sort the rang as follows:
row 1 adam
row 2 alex
row 3 ann
row 4 arlene
row 5 ashley
row 6 benny
row 7 chris
row 8 duncan
row 9 ed
row 10 nick
Does anyone heve a clue to have this done because I have been trying but did't succeed yet in finding the correct code.
Regards
Rini