I need to pass work order statements in excel. the work order contains product code and quantity. this work order is transferred to the production team. based on the product required, they procure the raw materials. i want help in making an excel sheet, wherein on giving the work order, the raw materials required for the same is automatically deducted from the stock.
for eg: if work order is 50 litres of product 1, where product 1 is 50% raw material 1 and 50% raw material 2.
on entering this work order, 25 litres from raw material 1 and 25 litres from raw material 2 should be deducted automatically from the stocks.


pls help!
thanks in advance!