- Feb 25, 2021
- Office Version
I am fairly new to excel so please bare with me. I'm trying to make a checkbox in B2 create the "True/False" in A2. Then trying to make A2 activate a filter in all of C through F cells where True activates the filter for a specified word and False removes the filter. In this case I'm creating a filter for candy. So say the candy is Sweet, Salty, and Milk Chocolate. I want to be able to check the boxes with "Sweet" "Salty" "Chocolate" and have it pull up the products with the flavor combination. Is this even possible? I'll upload my data sheet when I get home in two hours on what it currently looks like.