How to make a live tracker that updates other cells as data is entered

[parkerryan]

I would like to track results for a quota for this year.

I have the year total which is 40,000. I would like to have someone be able to manually enter their numbers for each month that equal up to this 40,000 quota. They would then add their actuals.

I want the actuals to change with the quota.

So, let's say if the quota for
January is 3000
February is 4000
March is 2500

The actual for January is 2500, then the deficit of 500 should make February Quota go from 4000 to 4500.

If the Actuals for February is 5500, then the surplus should bleed over into March, and so on all the way down, if that makes sense.

Thank you for the help!!!!!!