I have inventory and order sheets, lets say I have 5 no’s of item A and on entering new order on order sheet, quantity from inventory sheet should get subtracted.
I am not sure formula can be used with cell from another sheet.Currently I added count and subtracted from inventory quantity. But worried it may not be final solution.
Am I missing something? Kindly help me