Problems Manipulating a Cash-Flow Template

[Sonicmint]

Hi,

Can anybody advise on how to turn this 12 month cash-flow template into a 60 day cash-flow:
http://www.glamba.co.uk/temp/cashflow-forecast-test.xls

I know it's a case of adding more columns (increase from 12 to 60) but every time I try to do this I mess up the cascading formulas - although I must admit I'm not great with Excel!


Many thanks in advance. Any help would be much appreciated.

 

[Logit]

I was able to copy / paste the range. The Month / Year at the top needs to be adjusted on the pasted section so it reads May-05.

The formulas for the other columns appear to adjust accordingly.