I have an excel sheet with drop down menus in column a and b. Dependent on what you select from column a (1,2,3,4), when you go to column b it then gives you sub options to choose based on your previous option. I used data validation for column a but I'm stuck on how to apply the sub filter
Solved by I. H. in 17 mins