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

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

Hello,

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!!!!!!

2. ## Re: How to make a live tracker that updates other cells as data is entered

The issue is you need two versions of the quota - original (hardcoded) quota (as this varies each month) and adjusted target quota.

e.g. If you insert an 'adjusted target quota' column as Column C, you can enter the following formula in cell C4 and copy down:
Formula:
`Please Login or Register  to view this content.`

3. ## Re: How to make a live tracker that updates other cells as data is entered

Is there a way to make this carry down through all the values. So my quota for every month will update with the + or - quota. So if there are 12 months and I get +400 for the first month that 400 should be divided out

4. ## Re: How to make a live tracker that updates other cells as data is entered

Something like this? ExcelExample (2) - Copy.xlsx

Can be tidied to remove the helper columns etc, but before investing time on this good to know if it has the desired functionality

5. ## Re: How to make a live tracker that updates other cells as data is entered

This is exactly what i'm looking for! OMG!

One thing I noticed is that when there is a surplus. Let's say 5000 Actual to 4,000 Quota. The formula adds a + per month, when instead it should be taking it away. Essentially, if we go above by 1,000. That means that 1,000 per month is not needed for the rest of the year since we hit our quota + more. If that makes sense?

Also, do the January and February work or am I just looking at it wrong? Thanks so much man. you are a lifesaver.

6. ## Re: How to make a live tracker that updates other cells as data is entered

You're right, got it the wrong way round and there's another bug. Two corrections to make:

Cell L3, change the formula to:
Formula:
`Please Login or Register  to view this content.`

Cell M3, change the formula to:
Formula:
`Please Login or Register  to view this content.`

Hopefully then Jan and Feb will work as expected too

There are currently 1 users browsing this thread. (0 members and 1 guests)