I am writing a Excel spread sheet for stock visibility. It has ten columns and 102 lines.
column A is the name of the product, B is how many in the warehouse, C is how many available of the product, D is committed stock, E delivered stock, J received stock. The others columns have no bearing on the sheet or formulas.
the formulas are,
B= J2- E2,
C = B2 - D2
So I manually put in 1 in column D (committed stock) which then reduces Column C (available) by 1/ or the amount you first entered.
What I'm trying to do is when I then deliver the goods, I manually increase the number in column E ( Delivered) I want the number in column D(committed) to reduce by the same amount automatically.
this needs to be done with out effecting the rest of the spread sheet and I still need to be able to manually change column D with out changing anything else.