Any ideas for a variation on this -

I have sheets set like this-

<MonthType1<MonthType2<MonthType3<PreviousMonth Type1<PreviousMonthType2<PreviousMonthType3
etc....

I want to maintain the order of the grouping, but summarize each typ
(SummaryType1, SummaryType2, SummaryType3) with formulae that wil
automatically update when I add new sheets each month. Is i
possible?

Seems like the First:Last trick won't quite work given the groupin
order of the sheets...

Thanks for any help

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