Copying a Carry Forward Balance from Worksheet to Worksheet

[Guest]

All,

I have a workbook that reflects a cheque account. Each month is represented by one worksheet and each worksheet has a closing balance that I want to carry forward to the next worksheet (month). I can do this by entering the formula to look at the previous worksheet final balance but when I copy/insert a new month the carried forward balance is being carried forward from the wrong sheet (i.e. last but one).

I need a formula that I can copy with the sheet so that I do not have to remember to change it each month

Can anyone help?
Thanks

 

[jaf]

Hi Jo,
This works if your sheets are named sheet1, sheet2 etc.

=INDIRECT(LEFT(MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,34),5
)&(RIGHT(MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,34),LEN(MID
(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,34))-5)-1) & "!A1")


The only thing you may need to change is the last "!A1" shown. Change it to
the cell that contains the previous balance.
If the value you want is in e205 then use "!E205". Use the quotes.

--

John

johnf202 at hotmail dot com

All,

I have a workbook that reflects a cheque account. Each month is

represented by one worksheet and each worksheet has a closing balance that I
want to carry forward to the next worksheet (month). I can do this by
entering the formula to look at the previous worksheet final balance but
when I copy/insert a new month the carried forward balance is being carried
forward from the wrong sheet (i.e. last but one).

I need a formula that I can copy with the sheet so that I do not have to

remember to change it each month