Ana Sheila Martins
New member
- Joined
- Nov 3, 2011
- Messages
- 4
- Reaction score
- 0
- Points
- 0
Good morning,
I need a little help with a project I am working on. What I have is an incident alert system. I have attached an example workbook (Excel 2003) for easier understanding.
On sheet 1, column B4, I have a Data Validation List, whereby a user can select which area is being problematic. Column C is a free-text cell where they can type in a short message explaining what the problem is. Column D is a button that they click that will fire off an email to a group of managers.
Sheet 2 is a list of all the areas and the manager responsible for that area.
What I need is a one-button macro that will:
1) In Sheet 2 column A, automatically apply a filter, based on whatever is currently the value of Sheet 1, B4.(whatever the user selects from the dropdown list). This will possibly be a filter based on ActiveCell value, I think?
2) Send off an email to each manager of the area that has been filtered in step 1.
2.1) The contents of Sheet 1, B4 and C4 should be the body of the email.
Example:
To: John Smith(12345@smsprovider.com); Samuel Jackson(54321@smsprovider.com)
Subject: SMS (this subject is always fixed as, yes, it's actually sending a text message via email to the manager's cell phone)
Message:
Incident: (value of Sheet 1, B4)Lobby - (value of Sheet 1, C4)Strange man loitering in the lobby.
Is this possible?
I hope I've explained clearly enough what I need. I'm not great at that. :s
Thank you very kindly in advance for your assistance.
I need a little help with a project I am working on. What I have is an incident alert system. I have attached an example workbook (Excel 2003) for easier understanding.
On sheet 1, column B4, I have a Data Validation List, whereby a user can select which area is being problematic. Column C is a free-text cell where they can type in a short message explaining what the problem is. Column D is a button that they click that will fire off an email to a group of managers.
Sheet 2 is a list of all the areas and the manager responsible for that area.
What I need is a one-button macro that will:
1) In Sheet 2 column A, automatically apply a filter, based on whatever is currently the value of Sheet 1, B4.(whatever the user selects from the dropdown list). This will possibly be a filter based on ActiveCell value, I think?
2) Send off an email to each manager of the area that has been filtered in step 1.
2.1) The contents of Sheet 1, B4 and C4 should be the body of the email.
Example:
To: John Smith(12345@smsprovider.com); Samuel Jackson(54321@smsprovider.com)
Subject: SMS (this subject is always fixed as, yes, it's actually sending a text message via email to the manager's cell phone)
Message:
Incident: (value of Sheet 1, B4)Lobby - (value of Sheet 1, C4)Strange man loitering in the lobby.
Is this possible?
I hope I've explained clearly enough what I need. I'm not great at that. :s
Thank you very kindly in advance for your assistance.