Please check the attached file for sample
I have a complex issue regarding dropdowns. I need three dropdowns (dependent). Can you suggest the best vba way to do this?
1. if user selects Q1 for quarter dropdown, then he ONLY sees M1,M2,M3,M4 as choices for the month dropdown
2. Then, if user selects M1 for month dropdown, then he ONLY sees W1,W2,W3,W4 as choices for the week dropdown
What I am envisioning – is this possible within Excel’s architecture? Or I am overthinking :(