Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I automatically alphabetize multiple worksheets in a singl.
I have about 35 named worksheets in a workbook, and I would like to organize
the sheets alphabetically. Is there a way to do this without moving each sheet individually by hand? I'm using Excel 2002. Thanks! |
#2
|
|||
|
|||
You can use a macro:
Chip Pearson's: http://www.cpearson.com/excel/sortws.htm David McRitchie's: http://www.mvps.org/dmcritchie/excel...#sortallsheets If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm TS wrote: I have about 35 named worksheets in a workbook, and I would like to organize the sheets alphabetically. Is there a way to do this without moving each sheet individually by hand? I'm using Excel 2002. Thanks! -- Dave Peterson |
#3
|
|||
|
|||
Do it with VBA macro.
Chip Pearson has the code on his site. http://www.cpearson.com/excel/sortws.htm If not familiar with VBA and macros, see David McRitchie's site for more on "getting started". http://www.mvps.org/dmcritchie/excel/getstarted.htm In the meantime.......... First...create a backup copy of your original workbook. To create a General Module, hit ALT + F11 to open the Visual Basic Editor. Hit CRTL + R to open Project Explorer. Find your workbook/project and select it. Right-click and InsertModule. Paste the code in there. Save the workbook and hit ALT + Q to return to your workbook. Run the macro by going to ToolMacroMacros. You can also assign this macro to a button or a shortcut key combo. Gord Dibben Excel MVP On Fri, 18 Mar 2005 16:11:02 -0800, "TS" wrote: I have about 35 named worksheets in a workbook, and I would like to organize the sheets alphabetically. Is there a way to do this without moving each sheet individually by hand? I'm using Excel 2002. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically number multiple sheets | Excel Discussion (Misc queries) | |||
Why do multiple circular references affect each other in a worksh. | Excel Discussion (Misc queries) | |||
Update multiple workbooks automatically | Excel Worksheet Functions | |||
how do I alphabetize items automatically in excel | Excel Worksheet Functions | |||
combining multiple pages from Web automatically | Excel Discussion (Misc queries) |