how can i sort work sheets within a work book in an ascending or desending
order.
exp; if i name sheets as 1 3 4 2 8 9 5, i need this be sorted 1 2 3 4 5 8 9
how can i do that. i use excel 2002

You can click and drag them by the tabs and move them to their rightful
locations--or you could run a macro:

Chip Pearson's:
http://www.cpearson.com/excel/sortws.htm

David McRitchie's:
http://www.mvps.org/dmcritchie/excel...#sortallsheets

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

Remember if you have more than 9 worksheets, you'll want to name them nicely:

01, 02, ...., 99




Dakkan wrote:

how can i sort work sheets within a work book in an ascending or desending
order.
exp; if i name sheets as 1 3 4 2 8 9 5, i need this be sorted 1 2 3 4 5 8 9
how can i do that. i use excel 2002

--

Dave Peterson