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? |
#2
|
|||
|
|||
Rob, have a look here,
http://www.cpearson.com/excel/sortws.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "robnab" wrote in message ... 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? |
#3
|
|||
|
|||
http://www.cpearson.com/excel/sortws.htm
You could also add sheets named say AAAA as the very first sheet and ZZZZ as the very last sheet, hide them and then sum between those two. -- HTH RP (remove nothere from the email address if mailing direct) "robnab" wrote in message ... 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? |
#4
|
|||
|
|||
Better names might be 'first' and 'last'. By being hidden, new sheets will
automatically go after first and before last. -- HTH RP (remove nothere from the email address if mailing direct) "Bob Phillips" wrote in message ... http://www.cpearson.com/excel/sortws.htm You could also add sheets named say AAAA as the very first sheet and ZZZZ as the very last sheet, hide them and then sum between those two. -- HTH RP (remove nothere from the email address if mailing direct) "robnab" wrote in message ... 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? |
Reply |
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) |