Help Please

I am running a pc with Windows XP Pro and Office 03. I have limited experience with Excel. However I have been tasked with creating a spreadsheet to track our consumables in the machine shop. It is my hope to set the spreadsheet to automatically send an email to both my supervisor and myself letting us know the on hand quantity is below a specified value and we need to reorder the part or tooling. I also have a set of spreadsheets I have created for tracking employee production and errors. I would like some information from one to automatically transfer to the other. I will inquire more about this later. I figure I will start with the tracking spreadsheet now and go from there. Attached is the rough spreadsheet I am trying to create. Thank you in advance for your help.

 

No i haven't thought about MS Access. I Will provide some info to give a basic idea of what I'm looking for.

 

benhamj, welcome to the Forum.
As Keebellah suggested Access is far superior for doing what you want, in all three cases. It also has the major advantage that the data can be easily shared by others.
I have posted a few emailing databases quite recently.

 

THis is the updated worksheet.