Hello,I have a table of yearly totals for the amount spent by x. I also have a growth rate for each month so for example in 2001 in jan the growth rate might have been 0.3% and feb 0.5% What i want to do is for each month based on the growth rate and the total produce a value for each month which sum to the total amount. I hope this makes sense ii cant attach a spread sheet yet but i will upload one to any service you suggest so you can see it. If you need any more clarification please email me. i'm just a little stumped on how to do this. It's also important to note that it restarts each year.

Link for excel file is here: EXAMPLE FOR MISTER EXCEL.xlsx