Sorting Data

[lawmere]

Hi ,

please i want to find out how i can create a command on a worksheet to sort
out data without necessarily having to go the the toolbar to do this? Please
help as its quite urgent.

regards

Lawrence

 

[davesexcel]

use your macro recorder,
then assign a button to the macro(forms toolbar,Button, draw button o
sheet

 

[nsv]

or just use the keyboard ALT - D(ata) - S(ort

 

[lawmere]

Am sorry dave i dont seem to understand how to go about what you have said
could you please explain further???

 

[Dave Peterson]

How about an alternative?

Debra Dalgliesh has some code that allows you to click an invisible rectangle
floating over that column's header to sort by that column.

http://contextures.com/xlSort02.html


If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm