Sorting Worksheets by tab name

[Ernest Parker]

I have an Excel workbook which has more than 75 separate
worksheets. The worksheet tab names are not in
alphabetical sequence. For example, the sheet having tab
name "Nevada" comes before the sheet with tab
name "Alabama". Getting and keeping the tab names in
sequence manually is difficult. Is there a way to sort the
worksheets in Excel? If not, is there an automated method
(e.g., macro) for doing this?

 

[Chip Pearson]

Ernest,

See www.cpearson.com/excel/sortws.htm for code to sort worksheets.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

 

[Peo Sjoblom]

You need VBA for that, Chip Pearson has an example here

http://www.cpearson.com/excel/sortws.htm

 

[John Wilson]

Ernest,

I think you'll find what you're looking for here:
http://www.cpearson.com/excel/sortws.htm

John