Forum Discussion
Drop down list
I want to create dependent drop down list but at the same time I want them to be automated (if possible). For example, say I've got a list of 5 car makers in my main drop down. Then I'll get to choos...
Hi,
This is can be done by some tricks in data validations which involve the named ranges and INDIRECT function.
Watch this https://www.youtube.com/watch?v=-78bH0RZ7MA to learn these tricks.
Regards