We have done a pantry inventory, and want to make a shopping list sheet. We would like things to auto add to the shopping list when they reach a certain level of stock.
So for instance,
If we have 12 soy milk in pantry, we want soy milk to add to the list when we reach 6, and we want to buy 12 at a time.
I am looking for a way to get a formula to do this. Is that even possible?
My column headings are
Item - Use by - Location - Stock - Minimum stock - Amount to buy
I just need the Item and amount to buy to copy to shopping list when the minimum stock is reached.
Am I dreaming?