New to this place-looking for an excel expert

[jrumbuc]

Looking for help with a worksheet. I can explain details as follows:

The spreadsheet has multiple worksheets that get info entered as to the swab results taken. I would like it set up to total the number of good and bad swabs and give a percentage result. If possible can an out of spec (Bad swab) automatically generate an email to the dept with the bad swab? If this could happen it would be great. It may help to see the spreadsheet but this is what I am thinking, but it is a work in progress. Thank you

 

[VoG]

Take a look here http://www.rondebruin.nl/mail/change.htm

 

[hi_vishy]

Looking for help with a worksheet. I can explain details as follows:

The spreadsheet has multiple worksheets that get info entered as to the swab results taken. I would like it set up to total the number of good and bad swabs and give a percentage result. If possible can an out of spec (Bad swab) automatically generate an email to the dept with the bad swab? If this could happen it would be great. It may help to see the spreadsheet but this is what I am thinking, but it is a work in progress. Thank you

This is very much possible, can you provide more details...as to what is a swab, whats the input data format like and and how do you want the output (its format).

 

[jrumbuc]

How do I load a file of the spreadsheet to help explain what I am looking for?
Thanks

 

[VoG]

Try this http://www.excel-jeanie-html.de/html/hlp_schnell_en.php

 

[jrumbuc]

Thank you VOG I will look at the links