A few days back needed an excel sheet which had dynamic dependent drop down list.
I had to choose one unit, based on that choose the second thing and based on the first two choose the next thing. Sounds easy. Go try.
Following two resources gave some glimmer of hope but it nose dived as soon as it met my requirement. But….
After half a day of fruitless experiments, and a night’s sleep,the problem was solved.
With a little combination excel vba and some formulae, got what I wanted.
So here’s my take on getting 3 dependent dynamic drop down in excel. Enjoy!!
The excel sheet can be downloaded from here!