Can I get a cell to automatically rezero after entering a value. H

  • Thread starter Thread starter Kanta1435
  • Start date Start date
K

Kanta1435

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
 
Back
Top