Sorting data help

C

Conner Stevens

Apologies if this is posted to the wrong group. I have a worksheet that has
5 columns of data that I would like for other users to be able to sort by
clicking on a button or drop down. I assume this will be a VBA function. Can
someone point me to a reference that will help me do this?

Regards,


CS
 
P

Paul B

Conner, record a macro when you do the sort and assign it to a button, tools
record macro, give it a name and store the macro in this workbook, do your
sort, click the stop recording button, then view tool bars, forms, click on
the button then click on your sheet a box will come up to assign a macro,
pick the one you just recorded. You can right click on the button and change
the caption on it, you also can chose properties when you right click and
change some other things there. Hope this will get you started.

You may also what to have a look here on getting started with macros
http://www.mvps.org/dmcritchie/excel/getstarted.htm


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Top