I am trying to create a drop down box that will automatical populate other
boxes.
I have a worksheet with a list of Locations with their latidue and longitude
coordinates. I am trying to make a drop down box in another worksheet where
I select the location and then excel automatically fills in the next 2 colums
with the lat/long data. Is there a way I can make this happen?