previous number not changing

[Guest]

I have a worksheet that shows inventory of a particular item. This sheet
shows the item on order, received and a current balance. My question is how
would I continue to keep introducing qunatities into the "on order" column
without having to add up the quantity on a calculator and then replacing the
number. Is there some way for this particular cell to remember the previous
number and then add the new quantity to it? This item is ordered on a
regular basis.

"on order" received current balance
100 50 50

 

[Guest]

You might try making a column for a max inventory amount then
you could in you on order column subtract max amount from current balance
Column A Formula =D2-C2
A B C D
1 "on order" received current balance MaxAmount
2 100 50 50 150

 

[Guest]

Thanks mike for the quick response....that is food for thought. The only
problem is that this particular item is being ordered on a regular basis and
sometimes we order more even when we havent received the previous order and
in extreme situations we will order again on top of that. Any thoughts? I
basically want to be able to type in an amount ordered and it remember the
previous number. When I put "received" in, it automatically takes out of
the "on order" amount.

Thanks,

Rick