Copying a Carry Forward Balance from Worksheet to Worksheet

Giganews Newsgroups
Subject: Copying a Carry Forward Balance from Worksheet to Worksheet
Posted by:  Jo-FT
Date: Fri, 24 Oct 2003

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

Replies