hi

i am maintaining an inventory which has all the stock in sheet1 and the consumed or u may say removal is maintained in sheet2 total monthly receipts and consumption of material is on sheet3.

my question here is can anyone make the formula that sheet2 consumption deducts the stock from sheet1 and adds up as consumption in sheet3,

my sheet becomes like that of tally9 can anyone help on this issue please.