|Subject:||Copying a Carry Forward Balance from Worksheet to Worksheet|
|Date:||Fri, 24 Oct 2003|
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?