how can I sort sheets within a workbook in excel

P

piagax2

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?
 
P

piagax2

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

Bob Phillips

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 said:
not sure where to put that formula given from c.pearson or how to go about
doing it
Click to expand...
sheets?
 
Top