Clélia-elsa has attended:
Excel Advanced course
Drop down lists
how to create a second drop down list that update based on the value of the first one.
eg. if I have two columns, one with countries and one with cities, if I select USA in the first drop down column, then I only see in my second drop down the cities in the USA
RE: drop down lists
Hi Clélia-elsa,
Thank you for the forum question.
Please find attached file.
If you click in column A you can select a country. This will control the cities you can select in column B. I am using dynamic ranges so I can add more countries and cities without updating the rules. Select column B inside the dynamic range and click datavalidation, you can see how I reference the dynamic ranges in the Indirect function.
I hope my example make sense
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
datavalidation.xlsx
