Hi All!

I am a very inexperienced excel user and have been working on a spreadsheet for my boss and am in desperate need of some assistance.

The attached file is what I have come up with so far. Excuse the long winded formulas but like i mentioned above my excelpertise are limited

The input contractors sheet allows you to input the amount of 3/6 month contractors for a month and then shows the breakdown of contractors on our books for the next 3/6 months with 50% of the contractors falling off every 3/6 months.

What I need to do now is allow the 3/6 months to become a variable and the percentage (50%) of fall offs to also become a variable.

In addition I have to allow me to replace the forecasted figure with the...