Copying a Carry Forward Balance from Worksheet to Worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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


Jo-FT said:
All,

I have a workbook that reflects a cheque account. Each month is
Click to expand...
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
Click to expand...
remember to change it each month
 
Back
Top