I have a workbook with 26 worksheets all named by date.
is there anyway i can select all these sheets and have them running in date
order.
Thanks
Monty
You can use a macro to sort the worksheets.
Chip Pearson has the code.
http://www.cpearson.com/excel/sortws.htm
Gord Dibben Excel MVP
>I have a workbook with 26 worksheets all named by date.
>is there anyway i can select all these sheets and have them running in date
>order.
>
>Thanks