Forum Discussion
Automatic notifications to varying groups
Hello,
A single Excel spreadsheet is being accessed by multiple users. I know a macro can be used to notify users when it is modified. However, in our case the group of people who would need notification changes from time to time.
For example, if cell A1 is updated, people 1, 2, and 3 will need to know its contents (if possible, by email rather than by receiving an email and then having to open the spreadsheet).
Then if cell B1 is updated, people 1, 2, and 4 will need to know its contents.
The spreadsheet is updated too often to notify people 1, 2, 3, and 4 each time; only when they are concerned do I want notifications to be sent.
Is there a way to do this?
Hi Cara Evans,
I can make it and have some questions.
1. Where you want that result, in same excel sheet?
2. I can make it through help of Macro only. This will result (.xls or .xlsx will become .xlsm)
3. If you want results can seen by all users or only to you?
Reply to above questions. I will forward Macro enabled file.
Or if you can create macro, i give basic ideas to that.
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.
