Sorting

[Dakkan]

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]

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/buildtoc.htm#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