Hi all,
In the attached excel file, i have the below requirement:
Column D of sheet "DM PR Availability" contains a dropdown for selecting Do Not Disturb. Whenever a person selects Do Not Disturb, i want the no. of count to be displayed in the DM Dashboard sheet (accessible through Dashboard sheet) under column M for that respective ID. Please note that the count should be displayed only when Do Not Disturb is selected and not when that cell is deleted.
Note: Sheets : "DM Records", "DM PR Availability" and "Dashboard" will be in Protected Sheet and Protected Workbook state.
Can anyone help with my requirement. Many thanks in advance.
Bookmarks