I am making an excel database for my business stock levels. I am going to produce a receipt in the same document but a different worksheet. Is there a formula that would allow me to minus the quantity processed in the receipt from the stock levels in the main worksheet? Or have I got to manually update these levels every time I sell something and process a receipt?
Thanks