Hi,

I need some advice. I am new to the forum so I apologies in advance if I break protocol. I think this i the right place to post my enquiry and I'd really appreciate some help.

I am currently building a complex cash flow forecast, I have one Tab designated as the master sheet showing a snapshot of all incoming and outgoing, I then have multiple tabs representing different contract. The master sheet will show the contribution of each other sheet as a snap shot without going into detail as to how that number was derived. At the moment its easy , we have 2 major contracts I can simply find the cell that shows the net contribution from the contract and copy it over to the master sheet and drag it across to show the month on month contribution. What I want to do is show what happens as the business grows , so show what the cash flow looks like if in 6 months we add another contract. At the moment I am just copy and pasting the results into month 6 and dragging across to show the impact of plugging new business in in 6 months.

What I want to do is add a cell that dictates when the new contract start. So if I enter "6" into this cell it will paste the results into month 6 , if I enter 3 it will paste the results into month 3. I can then forecast that in the next 3 years we bring in 10 new contracts but have a switch which dictates when each one kicks in.

I hope the above makes sense and I would really appreciate some help.

Matt