Sort Column

[Tanya]

I have a sheet with a range A6:BP6 and I want to be able to sort by column
after a message prompt to select the column to sort by. Is this possible?

I have tried autofilter and it and found I needed to unlock the workbook
before accessing this feature, furthermore, for some reason it wouldn't sort
1-20 correctly, instead it started sorting from 10. Perhaps there is a
problem with the workbook?

Anyway it would be helpful if I could use a command button to run a macro
for this task. I already have a macro called Protect and another called
UnProtect to get around the locked workbook.

Any assistance would be appreciated.

Regards
Tanya

 

[Gord Dibben]

Range A6:BP6 is one row.

How do you expect to sort one row by a column?

Do you mean you want to sort columns A:BP starting at row 6?

What is the full range of your data and are you sure 1-20 are numbers and not
text?


Gord Dibben MS Excel MVP

 

[Tanya]

Sorry Gord you are quite right,
Range is A6:BP306
Thanks

 

[Tanya]

Also Gord
Column BN has the Rank formula, hence I would like to list students in order
of rank, alternatively i may like to sort by Class and LName in column A
Again I am sorry for the vagueness. This has been difficult to explain.
In the foreseeable future I can only see a need to rank all classes [300
students] and perhaps by only the top 10 or 20.