Hi there, might be a stupid question but need help.
Got a spreadsheet set up for stock. Now i need to be able to update the stock levels on 2 occasions
1 When stock is used
2 When stock recived
I need to know if there is anyway i can set it to update when the stock is recived or used in relation to the current stock. I have created a formuale that can update it but then when other stock is reived or taken it is not taken into account, so i need a formulae that can be changed as the book changes to reflect the stock status. I think i explaining this wrong.
I have a current stock level that will decrease over time as it does of 3/4. I have a used level of 1/4 leaving a level of 1/4. I now need to re order 1/4 to give me a half. How can i just update the re order level to make the current stock show a half with out changing anything else other than delteing the used level?
Please say if not understand