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
|