I have a spreadsheet that collects daily data. Each worksheet is labeled by the date. I.E. - Oct-1, Oct-2, Oct-3, etc.
Then I have a totals sheet at the end.
On the totals sheet, I have various columns that compile data from the daily sheets. But when I copy the formulas I've written - the cells will change as they go down the column (A3, becomes B3, becomes C3, etc) - BUT is there anyway to make the formula move to the next successive sheet?
So, for instance, I have:
=SUM('Oct-1'!E67)
Is there anyway, when I copy or drag it, It'll become:
=SUM('Oct-2'!E67)
without having to physically go in and change the name of the worksheet?
Thank you!
AW
This message was edited by apw420 on 2002-10-23 11:49
This message was edited by apw420 on 2002-10-23 11:49
Then I have a totals sheet at the end.
On the totals sheet, I have various columns that compile data from the daily sheets. But when I copy the formulas I've written - the cells will change as they go down the column (A3, becomes B3, becomes C3, etc) - BUT is there anyway to make the formula move to the next successive sheet?
So, for instance, I have:
=SUM('Oct-1'!E67)
Is there anyway, when I copy or drag it, It'll become:
=SUM('Oct-2'!E67)
without having to physically go in and change the name of the worksheet?
Thank you!
AW
This message was edited by apw420 on 2002-10-23 11:49
This message was edited by apw420 on 2002-10-23 11:49