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.
15 KB Views: 25