View Single Post
  #1   Report Post  
robnab
 
Posts: n/a
Default 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?