Hi,
I have started an Inventory Control sheet for my husbands business. He doesn't keep a lot of stock, but needs to know when things go in or out for ordering. I have set up the coloured balls to automatically indicate when stock is needed to be ordered, but would like to be able to automatically keep a running stock level. So in otherwords, when stock comes in, we can check it off with a checkbox and it automatically updates the Qty in stock with the new order. Hope I am making sense.
Please help!
Thanks.