![]() |
|
#1
|
|||
|
|||
![]()
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. |
#2
|
|||
|
|||
![]()
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) |
![]() |
|