Hello,

In column A, i have city names e.g. London, Paris, Rome, New york
The list will continue to grow as I visit new cities.

I would like in cell B1 to be able to select a city from column A.
I would like this selection feature to update automatically and recognise when new cities are added in column A.

however, there are a couple of barriers.
the drop down list feature in data validation cannot be used because there is a character limit in that and i dont want there to be a limit to the amount of cities i can visit.
also, the filter cannot be used because I am using it elsewhere on the sheet. its a long story, but the filter simply cannot be used.

any ideas?

thanks