I am trying to filter countries and then cities because I have calculations
that are specific to the exact spellings. My raw data is on one sheet, the
calculations I do are on another worksheet. A sample of the countries is
below.

Country City
AUSTRALIA ADELAIDE
AUSTRALIA BRISBANE
AUSTRALIA CAIRNS
AUSTRALIA CANBERRA
AUSTRALIA DARWIN NORTHERN TERRITORY
AUSTRALIA FREMANTLE
AUSTRALIA HOBART
AUSTRALIA MELBOURNE
BELGIUM ANTWERP
BELGIUM BRUGGE
BELGIUM BRUSSELS
BELGIUM DIEGEM
BELGIUM GOSSELIES


As I said, I would like to filter the country, then the city, otherwise,
using Data Validation lists all the cities without reference to the country.

Is it possible to filter the country on my calculation sheet and then the
city?

Scott