Hi all
Im trying to make a stock list using excel that shows Product, Product Code,
Amount in Stock and Minimum Stock to Keep. What i want to do is when someone
takes some stock and reception remove it from the Amount in Stock list, as
soon as the Amount in the Stock List matches the amount in the Minimum Stock
to Keep column a pop up appears and tells us we need to re-order more stock
of the item that is running low. Anyone know how i would go about doing this?

many thanks in advance