Excel : Advanced validation list

E

Elodie

I have a file with a column "Area" (Asia, Europe, America...) and another
"Country",
in the country column I would like the user is able to pick a country from a
list but depend on the area her/her has choose;
For eg: If the cell of the Area is "America" the Country cell should
display a list with only the American countries (US, Mexico, Canada,
Brazil.....).

It is possible to do with Excel?

Thank you in advance

Elodie
 
Top