abarganier
New Member
- Joined
- Dec 28, 2016
- Messages
- 2
Hi everyone! First time poster here. I have an excel dashboard with a drop down menu to select a clinic. Once the clinic is selected, the providers' names populate with the values for the table and charts. I also have checkboxes where you can select/deselect a provider for the clinic. (see screenshot)
My question is, how do I get the checkboxes to all be checked when the dropdown menu is changed? For instance, if I deselect two providers then change the dropdown menu to another clinic, my previous selections remain. I don't want that.
Image can be found here: https://drive.google.com/open?id=0BxpQ3jUntEEDUXpUYkI2WWV6YlE
My question is, how do I get the checkboxes to all be checked when the dropdown menu is changed? For instance, if I deselect two providers then change the dropdown menu to another clinic, my previous selections remain. I don't want that.
Image can be found here: https://drive.google.com/open?id=0BxpQ3jUntEEDUXpUYkI2WWV6YlE