I have 22 sheets with dientical layouts in a workbook. what i need is
macro fo some kind that will re-order the sheets in the workbook base
on the value in a particular cell (it will be the same cell in each o
the sheets).

Basicallly I have 3 sets of dates on these sheets and i need to be abl
to order the sheets in the workbook based on which one of these date
I need to sort by at the time (basically putting the earliest dates a
the front).

A macro that will sort the 22 sheets putting the earliest date in C1 a
the start would do. If i then need to order them by E1 instead the
I'll only have to change a tiny bit in the macro.

Thank

--
Message posted from http://www.ExcelForum.com