I don't have much experience/knowledge of macros, but I'm sure there's got to one out there that can do what I have in mind. Workbook with example is attached.
I have 3 main scenarios that a customer could choose. Based on what scenario they choose, there are certain products that come automatically with that scenario.
I would like someone to be able to:
1. (COMPLETE) Check a box to select which scenario they want (I have checkboxes already set up in Row 2 that do this part)
2. Once a scenario is selected, the other 2 scenarios cannot be selected at the same time (i.e. only scenario 1, 2, OR 3 can be checked, you can't check scenario 1 AND 2...)
3. Once a scenario is selected, the appropriate product checkboxes automatically check and product checkboxes for the other scenarios get unchecked (i.e. if I chose scenario 1, the appropriate products under scenario 1 would get checked but all products under scenarios 2 and 3 would get unchecked)
4. Keep the ability to check and uncheck manually (i.e. certain products come standard with scenario 1, but you have the option to check/uncheck a product to add/remove it ad-hoc)
The way the spreadsheet is set up now shows which products should be included in each scenario. I just can't get the macro to automate what I laid out above.
Thank you so much!!
Bookmarks