I have over 100 excel sheets i need put in alphabetic order,how?

[robnab]

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?

[Paul B]

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" <[email protected]> wrote in message
news:[email protected]...
> 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?

[Bob Phillips]

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" <[email protected]> wrote in message
news:[email protected]...
> 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?

[Bob Phillips]

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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?
>
>