Sorting worksheets within a workbook
 

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

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

Chip Pearson gives a sorting technique at
http://www.cpearson.com/excel/sortws.htm

--

HTH

RP
(remove nothere from the email address if mailing direct)


"CiceroCF" wrote in message
...
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