Forum Discussion
Solved
Data validation lists - flow chart?
Hello, I'm a school leader and I'm trying to create an Excel spreadsheet to track Teaching & Learning action steps that I give to teachers. I understand how to create a drop down list but what I'...
Hello Phoebe,
What you need is a dynamic dependent drop-down list. In the attached file, I inserted Lists sheet. You can add (or delete) categories of Dimensions of Depth and Dimension Focus. There is no more need to define additional named ranges.
Thank you Twifoo, that is exactly what I was looking for! I don't suppose you could explain how you did that, or point me in the direction of a tutorial for what you did?
I'd like to learn for myself as well so that I can recreate this with other subjects in future
I sent you a private message for the instructions.
