how can I sort sheets within a workbook in excel
 

I have an excel spreadsheet that I am doing and it has about 100 sheets
within the spreadsheet (tabs on botom) Is there a way to sort those sheets?

how can I sort sheets within a workbook in excel
 

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

--

HTH

RP
(remove nothere from the email address if mailing direct)


"piagax2" wrote in message
...
I have an excel spreadsheet that I am doing and it has about 100 sheets
within the spreadsheet (tabs on botom) Is there a way to sort those
sheets?

how can I sort sheets within a workbook in excel
 

not sure where to put that formula given from c.pearson or how to go about
doing it

"piagax2" wrote:

I have an excel spreadsheet that I am doing and it has about 100 sheets
within the spreadsheet (tabs on botom) Is there a way to sort those sheets?

how can I sort sheets within a workbook in excel
 

It is VBA not a formula.

From Excel, Alt-F11 to get to the VBIDE. Menu InsertModule, and then copy
Chip's code.

Go back to Excel. Menu ToolsMacroMacros.., select the macro from the list
and click Run.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"piagax2" wrote in message
...
not sure where to put that formula given from c.pearson or how to go about
doing it

"piagax2" wrote:

I have an excel spreadsheet that I am doing and it has about 100 sheets
within the spreadsheet (tabs on botom) Is there a way to sort those
sheets?