I have a worksheet that lists job numbers in column A, in column H I have a drop down list of potential users (around 7 users). What I want is when I enter a new job number and then select a user from the dropdown list it will automatically send an email to that user saying your job number is xxxxxx (or whatever it is) from column A in the same row.
This form will be ongoing so I need it to ignore any job number and user that are above it in the list.
I should also mention that I want this to be a sub function.
Thanks for you help...
Bookmarks