Hi all,

I'm wondering if anyone can help. I have a number of stock items.

Beside each of them, there is a drop two choices "in stock" and "checked out".

For each stock item i will also have a cell which shows the quanitiy in stock.

What i want is to allow someone to take an item from my stock store and in the excel worksheet, I want them to be able to choose "checked out" from the dropdown box, which will then decrease the stock. When the stock reaches a certain value, a prompt in the form of a message box will appear to email a specific address to ask someone to reorder more.
So my main two points are :
(1) How to decrease/increase the value if "checked out" is selected or if "in stock" is selected.

(2) How to have a message box pop up which will link to opening the email outlook client in order to send an email to notify that new stock is required?

I have excel 2007.

any help would be appreciated.

Thank you.