Numerical ordering

[katejmchugh]

I have a worksheet with several hundred tabs that are all numerically labeled. New tabs get added all the time and I am trying to see if there is a way to have Excel automatically organize them in numerical order. So I don't have to do it myself evertime.



Thanks for your help.

[OTPM]

Hi Kate
I found this solution on the Web which appears to provide that functionality:@
ASAP Utilities

slypimpb | Fri, 27/08/2004 - 16:54 | Permalink
I would recommend a very excellent addin for Excel called ASAP Utilities. You can find it here:- http://www.asap-utilities.com/
It's a freeware add-on with a large library of useful functions not built into Excel. You'll probably never use most of them, but I've found some very useful. Installation is simple, and I would recommend anyone who uses Excel on a regular basis to install it and have a play around.
The function you are after is in the "Sheets" menu - "Sort all sheets in alphabetical order"

Good luck.
Tony (OTPM)