Hi all,

My excel file is help for keeping goods amount, anyone who take goods is
need to update the file. A cell is contain each item minimum value and if
that item reach the minimum level we have to order the related items.

Two columes are for +/- goods, one cell (say A1) is a simple formula that
show the balance by calculating the +/- of the two colume and one cell
contains the minimum value.

My problem is, we sometimes take a stock checking, the value after checking
basically should replace the value in cell A1, but it is not a practicable
way since if replace the cell A1 to the after checking value , further +/-
cannot be calculated. Any idea? Thanks