Creating dynamic range with dependent dropdowns

Hello All
Need help regarding dynamic ranges for drop-downs. There are specific work types. Each work type can have several activities. I created named ranges to help. As user selects a work type, the possible set of options appears for that specific work type ¿ shows up in [Activity] column as a drop down. Now whenever I am creating a dynamic range for the set of activity for [Managerial] work type, the activity drop down is not working.
The activity list for each work type will expand; hence a dynamic range for those activity sets is needed. But when I do it, the drop down doesn’t work.
Thanks in advance
-R
DynamicRange4DropDown.xlsx
RayneAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
leptonkaConnect With a Mentor Commented:
Hi,

I used Tables. You can see the 3 columns are coloured, has filter and has a small arrow at the bottom-right corner. There are some features of tables.
Table automatically captures new data added to the next empty cell at the bottom - so it is dynamic itself.
When you click on a cell within a table you will see a new menu in the header of your Excel window: Table Tools. If you click on it, you will find a Resize button at the left hand side - you can edit the table range with it.

Hope it helps. (Sorry if my english is not perfect - I am Hungarian :-)
Cheers,
Kris
0
 
leptonkaCommented:
Hi,
I created you the attached using tables. You can add new items to any of your lists.

Cheers,
Kris
DynamicRange4DropDown-s.xlsx
0
 
dlmilleConnect With a Mentor Commented:
As an add-on to the great solution Kris has helped you out with, you might like this article, if you are going to have an extensive list for your drop down validation list, and you'd like to ensure its a unique list that is sorted.  There's an add-in utility at the bottom fro DynamicDV!

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/A_6429-Part-II-Drop-Down-List-with-Unique-Distinct-Values-ComboBox-ListBox-and-Data-Validation-List-Bonus.html

Please vote YES if you find it helpful.

Cheers,

Dave
0
 
RayneAuthor Commented:
Hello Kris & David,

Thanks you for your replies and David for your enhanced dropdown idea.
Thanks for your help.

I didn’t understand how you made the dependent dropdowns as having dynamic sources in the original attached file [dynamicrange4dropdown]. If you could explain that will be great. Further, I see that I can’t edit the Range for the names ranges. I guess that’s because of something you did to make the dynamic source work.

Thank you
R
0
 
RayneAuthor Commented:
Thank you Kris ;) This was very helpful and I Vote Yes for Davids add-in as well
0
All Courses

From novice to tech pro — start learning today.