I am trying to create a sheet that contains a drop-down list of countries (B2) and in F2 I would like to have a drop-down list with the cities of the country I select in B2. See attached sample for clarification. Does anyone have a solution to this? I can't use Data Validation because I have too many countries. Any help would be highly appreciated.
Thank you in advance for your time.