I'm trying to create a spreadsheet that calculates inventory with a column
for initial inventory), total inventory used, Inventory remaining, and a
column where you add in the quantity used for the last order and it
automatically deducts the quantity used from the balance. I'm running into a
problem where the number that I enter in the 'quantity used' column remains
and when I make other changes in the same row, it deducts the quantity used
an additional time. If I could get the value that I enter to go to zero, or
the cell to clear after I enter a value, my problem would be solved.

hi
from your post, i suspect that you might have a "worksheet change" event
running in the background. is this true?? if so, post your code.

regards
FSt1

"Kanta1435" wrote:

I'm trying to create a spreadsheet that calculates inventory with a column
for initial inventory), total inventory used, Inventory remaining, and a
column where you add in the quantity used for the last order and it
automatically deducts the quantity used from the balance. I'm running into a
problem where the number that I enter in the 'quantity used' column remains
and when I make other changes in the same row, it deducts the quantity used
an additional time. If I could get the value that I enter to go to zero, or
the cell to clear after I enter a value, my problem would be solved.