Workbook date order

[Monty]

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

 

[Gord Dibben]

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