Nathan Lovell
New Member
Hello
I am using excel 2013 and what I would like to do is this -
sheet one which is called Level 1, every time I enter A for awarded in a column say C4 to C30 I want it to take one badge off the stock list page which would be D8.
So it would go something like this, one week I enter A in C10 on the level 1 tab and if I have 20 badges I want it to count down so there would be 19 badges left in stock but then the next week I mite want to enter A in C20 and have one less badge so there will be 18 left. Can anyone help me with a formula for this?
I am using excel 2013 and what I would like to do is this -
sheet one which is called Level 1, every time I enter A for awarded in a column say C4 to C30 I want it to take one badge off the stock list page which would be D8.
So it would go something like this, one week I enter A in C10 on the level 1 tab and if I have 20 badges I want it to count down so there would be 19 badges left in stock but then the next week I mite want to enter A in C20 and have one less badge so there will be 18 left. Can anyone help me with a formula for this?