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.
Hi, if you already know all about drop downs and especially about dependent ones, I would recommend performing with a more performing app like ms Access, relationships between tables, exact queries etc. otherwise I send you this tutorial.
https://m.youtube.com/watch?v=yychXPx2gUY
Greets, Eva
https://m.youtube.com/watch?v=yychXPx2gUY
Greets, Eva
Thank you for responding!
I know about dependent data lists but I cannot for the life of me get them to work and I don't understand why! It's very frustrating.
I'm watching YouTube tutorials and I'm copying what they do EXACTLY, yet it's not working. I don't understand what I'm doing wrong.
- Hi Phoebe,
I collude possibly help if you send some screenshots. First: Breathe...