UnluckyXIII
New Member
- Joined
- May 13, 2015
- Messages
- 20
- Office Version
- 365
- Platform
- Windows
Hey,
Hoping someone might be able to assist me with this one, I'm trying to setup an email function within my spreadsheet but I seem to be a little out of my depth (Excel isn't my strong point).
What I'm trying to achieve is that as my spreadsheet is updated that a cell can be clicked to send an email to a person selected from a data validation list (email address located in a different sheet in the same workbook), I seem to be able to setup the email function fine when everything is located together in the same sheet and the value isn't something that changes but as soon as I introduce the data validation list I just can't seem to figure out how to get this to work.
Hopefully the above makes sense and someone knows where I'm trying to go with this, although if you need more details or I haven't explained this very well please let me know.
Thanks in advance
XIII
Hoping someone might be able to assist me with this one, I'm trying to setup an email function within my spreadsheet but I seem to be a little out of my depth (Excel isn't my strong point).
What I'm trying to achieve is that as my spreadsheet is updated that a cell can be clicked to send an email to a person selected from a data validation list (email address located in a different sheet in the same workbook), I seem to be able to setup the email function fine when everything is located together in the same sheet and the value isn't something that changes but as soon as I introduce the data validation list I just can't seem to figure out how to get this to work.
Hopefully the above makes sense and someone knows where I'm trying to go with this, although if you need more details or I haven't explained this very well please let me know.
Thanks in advance
XIII