Yeah, array function; control+shift+enter. I got it as soon as I hit send.
What I want to do this is add a report page to the front of a workbook that
will summarize the information from the next six pages. The thing is the
next six pages are monthly reports so each month a new page is added right
under the front page.
Right now there is the Six Month Report (11/05-04/06) but at the end of this
month a new page will be added and the Six Month Report will be for
(12/05-05/06).
The report is an exact replica of the monthly reports except for the data.
Is there a way to write the formulae to take the next six sheets without
specifically naming what those sheets are?
Ben Karlin
St. Louis, MO
Bookmarks