I am creating worksheets that have MTD columns and YTD columns.
I am using the formula =SUM('march'!b1+a1) where b1 is the YTD total from the march worksheet and a1 is the MTD total from the april worksheet.
When I copy the worksheet to create one for a new month, I want the new worksheets formula to automatically be =SUM('march'!b1+'april'!b1+a1)
But what I am getting is that the formula remains =SUM('march'!b1+a1)
How do I do this???
This message was edited by joneric on 2002-04-19 22:19
I am using the formula =SUM('march'!b1+a1) where b1 is the YTD total from the march worksheet and a1 is the MTD total from the april worksheet.
When I copy the worksheet to create one for a new month, I want the new worksheets formula to automatically be =SUM('march'!b1+'april'!b1+a1)
But what I am getting is that the formula remains =SUM('march'!b1+a1)
How do I do this???
This message was edited by joneric on 2002-04-19 22:19