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

On Fri, 30 Sep 2005 07:33:04 -0700, "Monty"
wrote:

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