Creating UserForms in Excel

[RayzGurl]

I am creating a userform for tracking purposes. I know that you can set a spreadsheet to automatically route a copy of the spreadsheet to an email address. However, I do not want it to route the entire spreadsheet everytime someone makes an entry. I just need it to route a copy of the entry. Is there a way to route just a copy of the entry?

Thanks
Pam

 

[Razygurl]

Thanks Nigel,

This is exactly what I was wanting.

:-D