I have created a workbook in Excel 2003, there are lots of worksheets within
this workbook. Basically I am trying to monitor an accumulative balance. My
first worksheet splits down all entries for a particular project. Each
additional worksheet then splits these entries down per month (each of these
worksheets is linked to the first worksheet). I want a cell on each of the
additional worksheets to calculate the accumulative balance, which would be
the expenditure for that month + expenditure for all previous months e.g. my
spreadsheet for July would calculate April+May+June+July and so on. I tried
paste special (values+add), from one worksheet to the next but if I amend any
data in the first worksheet, the additional worksheets do not change, I have
to paste special again. I really really don't want to have to link all of
these sheets up manually, any suggestions????

Take a look at using 3d references. Assuming your worksheets are physically
in chronological order, your June sheet could have a formula like:
=SUM('January:May'!A1)

Where A1 is the cell that contains that month's balance.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Mikki Shaw" wrote:

I have created a workbook in Excel 2003, there are lots of worksheets within
this workbook. Basically I am trying to monitor an accumulative balance. My
first worksheet splits down all entries for a particular project. Each
additional worksheet then splits these entries down per month (each of these
worksheets is linked to the first worksheet). I want a cell on each of the
additional worksheets to calculate the accumulative balance, which would be
the expenditure for that month + expenditure for all previous months e.g. my
spreadsheet for July would calculate April+May+June+July and so on. I tried
paste special (values+add), from one worksheet to the next but if I amend any
data in the first worksheet, the additional worksheets do not change, I have
to paste special again. I really really don't want to have to link all of
these sheets up manually, any suggestions????

Yes that seems to work, thanks you've saved me sooo much work!!!

"Luke M" wrote:

Take a look at using 3d references. Assuming your worksheets are physically
in chronological order, your June sheet could have a formula like:
=SUM('January:May'!A1)

Where A1 is the cell that contains that month's balance.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Mikki Shaw" wrote:

I have created a workbook in Excel 2003, there are lots of worksheets within
this workbook. Basically I am trying to monitor an accumulative balance. My
first worksheet splits down all entries for a particular project. Each
additional worksheet then splits these entries down per month (each of these
worksheets is linked to the first worksheet). I want a cell on each of the
additional worksheets to calculate the accumulative balance, which would be
the expenditure for that month + expenditure for all previous months e.g. my
spreadsheet for July would calculate April+May+June+July and so on. I tried
paste special (values+add), from one worksheet to the next but if I amend any
data in the first worksheet, the additional worksheets do not change, I have
to paste special again. I really really don't want to have to link all of
these sheets up manually, any suggestions????