ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel work Book Order (https://www.excelbanter.com/excel-worksheet-functions/149225-excel-work-book-order.html)

Wills

Excel work Book Order
 
How do I get an Excel Work to automatically place Work Sheets in Numerical
Order?

Dave Peterson

Excel work Book Order
 
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...#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

Wills wrote:

How do I get an Excel Work to automatically place Work Sheets in Numerical
Order?


--

Dave Peterson


All times are GMT +1. The time now is 02:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com