title: Cascade drop down list in excel(dynamically)
body: <p>I have two set of excel values which I am generating dynamically named "category" and "value list". I am assigning those values for two named ranges and use them in a drop down list.(data validation list).</p>
  
  <p>"value list" is depends on the selection of category. I want to create a casacde drop down based on those dynamic values . I found several posts but there are static lists.</p>
  
  <p>Here is one post I found <a href="http://mauriceausum.wordpress.com/2011/07/12/cascading-combo-boxes-in-excel/" rel="nofollow">cascade drop downs</a>
  Can anybody suggests a good way to do this</p>
  
  <p>Thanks</p>