Ensure that if new cities are added to the list of cities in Problem 9, the drop-down

Question:

Ensure that if new cities are added to the list of cities in Problem 9, the drop-down menu will include them.

Data from in problem 9

The file named Latitude.xlsx contains a formula to compute the distance between two cities using their latitude and longitude. The file also contains the latitude and longitude of various US cities. Set up a drop-down menu so that when you select a city in cell P2 and another city in cell Q2, the distance between the cities is computed in cell Q10.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Question Posted: