| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to save sheets in new excel files, automatically? | Excel Worksheet Functions | |||
| In Excel, how do I print the workbook sheets to 2sided paper? | Excel Discussion (Misc queries) | |||
| How to hyperlink from a workbook to sheets in another workbook? | Excel Worksheet Functions | |||
| Should be able to name Excel sheets based on cells in workbook | Excel Discussion (Misc queries) | |||
| Stubborn toolbars in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
