Enter One Figure & Populate Colum

[ccsnet]

Hi All,

I've attached an image to show what I would like to do.....

I have the need to show dynamically capitalisation over a set period vs the over all income.

This would mean taking the figure in RED ( £4800 ) which is the total capital and only populating the following boxes based on the number of months set by the user ( 3 in this case ).

Does any one know of a way I can do this is automatically so the user only enters the number of months to capitalise over and total income figure ?

T

[ccsnet]

excelq.png

Sorry - there seems to be an issue with attachments....

T