How do I get an Excel Work to automatically place Work Sheets in Numerical Order?
W Wills Jul 6, 2007 #1 How do I get an Excel Work to automatically place Work Sheets in Numerical Order?
D Dave Peterson Jul 6, 2007 #2 You can click and drag them by the tabs and move them to their rightful locations--or you could run a macro: Chip Pearson's: http://www.cpearson.com/excel/sortws.htm David McRitchie's: http://www.mvps.org/dmcritchie/excel/buildtoc.htm#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
You can click and drag them by the tabs and move them to their rightful locations--or you could run a macro: Chip Pearson's: http://www.cpearson.com/excel/sortws.htm David McRitchie's: http://www.mvps.org/dmcritchie/excel/buildtoc.htm#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
