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:
Related Book For
Microsoft Excel Data Analysis And Business Modeling
ISBN: 9780137613663
7th Edition
Authors: Wayne Winston
Question Posted: