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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
dlmilleCommented:
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
leptonkaCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
RayneAuthor Commented:
Thank you Kris ;) This was very helpful and I Vote Yes for Davids add-in as well
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.