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?

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

--

HTH

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


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

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?

It is VBA not a formula.

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

Go back to Excel. Menu Tools>Macro>Macros.., select the macro from the list
and click Run.

--

HTH

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


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