How can I shortlist cities based on the country selected in Excel

G

Guest

Column A contains all country names while column B contains all cities. I
want to create drop down lists by using data validation. When someone chooses
a particular country in column A, only shortlist cities in column B will be
displayed. How can it be done?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Double Drop-Down Validation in Excel 2007 1
linking values of column A to values of column B 2
Cascade Drop-Down Lists? 1
Dynamic list on a cell 2
How to auto populate many cells based on one cell 4
STILL NEED HELP.... 4
FIELD BASED FILTERATIONS 1
WHAT FUNCTION CAN I USE TO GET A NUMBER FROM ONE WORKSHEET TO ANO. 1

Top