Forum Discussion
Automatic notifications to varying groups
To answer your questions,
1. As an example,
Let's say that a number "120" is entered in cell A1. I want people 1, 2, and 3 to be notified (preferably by email) that 120 is the number that was entered.
Then person 2 needs to enter in "yes" in cell B1. I want people 1, 2, and 4 (but not person 3) to be notified that this was done.
Later a number "240" is entered in cell A2. I want people 1, 2, and 5 to be notified of the contents of this cell.
Then person 2 needs to enter "yes" in cell B2. I want people 1, 2, and 6 to be notified that this was done.
The people who are notified each time changes.
2. An xlsm file would be fine.
3. I want only the people concerned at each step to receive an email.
Okay done.
Let's Check whether i understood this concept correct.
1. You have blank excel file (macro enabled and it's a shared file which can be accessed and modified by other users)
2. For example, 10 users totally going to access this file (i don't know how many going to access).
3. If Person 1 enters value '120' in 'Cell A1' and closing that file. (e-mail will be sent to Persons 1,2,3)
4. If Person 2 enters value 'Yes' in 'Cell B1' and closing that file. (e-mail will be sent to Persons 1,2,4)
5. E-mail will not be sent to persons who made changes except persons 1 and 2.
6. E-mails will be sent to Persons 1 & 2 by default when users made changes.
Is these changes made to specific column or overall excel workbook.?
If anything wrong what i understood, Kindly forward instructions.
Only thing is you shoud furnish the user names and their e-mail ids.