Sorting Data
 

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

Sorting Data
 

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


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=522593

Sorting Data
 

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


--
nsv
------------------------------------------------------------------------
nsv's Profile: http://www.excelforum.com/member.php...o&userid=26500
View this thread: http://www.excelforum.com/showthread...hreadid=522593

Sorting Data
 

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

"davesexcel" wrote:


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


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=522593

Sorting Data
 

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

lawmere wrote:

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

--

Dave Peterson