Automate stock list

[Lurchybold]

Hi,

We have an excel sheet that is used for recording our stock check once a month, this is usually printed out and filled out by hand, hung on a nail in the office in the hope that someone will remember to order some stock once in a while. As you can guess we run out of stock on a regular basis.

Sorry but how do I attach the excel document so that you can see what I am talking about ?

I would like to automate this so that the ‘Stock level’ column is filled in on the PC, when the stock level falls below the ‘Min stock quantity’ level the ‘Order quantity’ column is automatically filled in with an order amount that is needed (this would be the minimum order quantity). Would it also be possible to have an automated e-mail sent when an order quantity is highlighted to 3 members of staff to ensure that at least we know that they have been notified that an order needs to be placed. The e-mails would be sent to the two person responsible for ordering his assistant and also to the MD.

Hope not asking for too much, willing to be talked through the work involved but I am not very literate with this type of thing,

Thankyou very much for reading this,

Best regards,

Andy