Help Please

[benhamj]

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.

 

[Keebellah]

I'd love to take a shot at it but that won't be 'til after January 3d. ('11)
For starters, check the different posts where emails can be sent, there are sereval, also where I did some coding.

 

[Keebellah]

I took a a quick look but your sheet is empty.
You will have to provide at least basic info like when to order, what is the threshhold, etc.

Put some data in to give an idea.

Have you considered MS Access?

 

[benhamj]

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

 

[OBP]

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.

 

[benhamj]

THis is the updated worksheet.