I’m pretty much new at using Excel (I have 2003), and I’m stuck.
I’m trying to create an inventory control sheet, I have several columns:
A= list of inventory items
B= quantity received, restock
C= quantity in stock
D= quantity sold on Monday
E= quantity sold on Tuesday
F= quantity sold on Wednesday
(ETC.)
I need to be able to enter a value in “B” (positive or negitive), have this value added to (or subtracted from) “C”, then have “B” reset to 0 without changing the value of “C” while still allowing sold items (D,E,F, etc.) to be subtracted from “C”.

Where I’m hung up is the data entry into “B”, on "enter", update “C” and reset “B” to 0, without changing “C”.

Any help would be appreciated.