View Single Post
  #2   Report Post  
CiceroCF
 
Posts: n/a
Default

I did find the answer to the 1st question at
http://cpearson.com/excel/sortws.htm, but it orders it as 1, 11, 2, 21, 21,
23, 4 and so forth... not a true numerical order..

"CiceroCF" wrote:

I update a logistics book with a form i created in Excel. I currently have
it setup as each updated page is a worksheet and is the name of that
worksheet, ie. 2354A. This is starting to create a headache keeping track of
the pages, which leads to the following:
1. Is there a way to sort the worksheets to put them in
alphabetical/numerical order by the name on the tab?
2. Is there a way to create a search function to find a worksheet?
possibly to search for 235* and it will return a listing 2350-2359?

After re-reading this, it is looking like i should create an Access
Database.... but that is a last resort...
Thanks for any help you can give....
Cicero