Thanks for your sample spreadsheet Savings.xls which I am starting to
understand. One question.

At the bottom there are three tabs labelled in the original master
spreadsheet Sheet 1, Sheet 2, Sheet 3. You have relabelled these 2005, 2006,
2007 and I understand why. This will do mef for three years. But I want the
programme to predict *30* years ahead. How do I do this; do I complete
another worksheet with formulas referring back to the first sheet, or what?
Grateful advice.

Mr W



"Mr Warwick" wrote in message
...
Thanks, will reflect

Mr W


"cheesey_toastie" wrote in message
ups.com...
You wouldnt need to programme anything.

Simply create a new workbook.

In column A put weeks 1-52.

Col B put your income from your pension
Col C put a formula that looks at the amount in your savings and
calculates your monthly interest payment (e.g. in col C =F1*0.05/52)
where F1 is the cell that has your current savings balance, 0.05 = 5%
annual interest and 52 is the number of weeks in a year).
Col D put in your expenditure (as a minus figure).
Col E put = SUM(A2:E2).

At the bottom of Col E put a sum formula e.g. =sum(E2:E53)

This would be your first sheet. Then copy this sheet, name it as next
year... change the entry in the savings amount to equal a formula that
says =2005!E53+2005!F1

Now copy this sheet and rename it 2007, 2008, 2009 etc etc changing
the formula in teh savings cell (F1) to be the result of hte sum in E54
+ F1 from sheet 2005.

I've emailed you a start,... note it needs formatting etc.

This solution would be oversimplified as it assumes that you don't earn
any interest from any money you have left each month.. but as a rough
guide would do.

The only thing programming would help in is to reduce the mundane task
of copying the sheet and changing the formula....

Hope this helps