A Dynamic Dependent Drop Down List in Excel

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….

  • A Dynamic Dependent Drop Down List in Excel
  • Create Dependent Drop Down Lists
  • 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!

    Advertisements

    Leave a Reply

    Fill in your details below or click an icon to log in:

    WordPress.com Logo

    You are commenting using your WordPress.com account. Log Out / Change )

    Twitter picture

    You are commenting using your Twitter account. Log Out / Change )

    Facebook photo

    You are commenting using your Facebook account. Log Out / Change )

    Google+ photo

    You are commenting using your Google+ account. Log Out / Change )

    Connecting to %s