| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
I have over 100 excel sheets i need put in alphabetic order,how?
Background: I have an index page with hyperlinks to each sheet, each sheet
has a COUNT function to add the entries and a SUM function on the index page which adds the result of each COUNT function, to do that I used "SUM(Birmingham:Worcester'!B2)" as each sheet has a geographical name a newly added sheet may not fall within the specified range and therefore may not be added. Is there a way to alphabetise these sheets? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparison / Check Off between 2 excel sheets. HELP NEEDED! | Excel Worksheet Functions | |||
| How can I merge multiple sheets from different Excel files workbo. | Excel Worksheet Functions | |||
| Create New Microsoft Excel Worksheet Has 3 Sheets | Setting up and Configuration of Excel | |||
| hot to access deleted information in excel sheets | Excel Discussion (Misc queries) | |||
| need an advice in excel sheets.... | Excel Discussion (Misc queries) | |||
Threaded Mode
