Miles Calculation?

[Ewing25]

Is there anyway to find the miles between the 2 places that are inputted into
2 different cells?

for instince if Los Angelas, CA is inputted into cell 1A and New York, NY is
inputted into cell 1B it will automatically put into cell 1C the miles
between them.

Is there anyway to do this?

Thanks

 

[Chip Pearson]

What distance do you want to measure? Driving distance? Great circle
distance? I have a workbook on my web site that lists the latitude and
longitude of about 1200 cities in the US and it has code and formulas for
calculating the great circle distance (shortest distance) between two
cities. See http://www.cpearson.com/Excel/latlong.htm for details and
download the workbook at http://www.cpearson.com/Zips/LATITU~1.ZIP .


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[Stuart Bray]

Is there anyway to find the miles between the 2 places that are inputted into
2 different cells?

for instince if Los Angelas, CA is inputted into cell 1A and New York, NY is
inputted into cell 1B it will automatically put into cell 1C the miles
between them.

Is there anyway to do this?

Thanks

Get a list of coordinates of your locations. Eg http://www.infoplease.com/ipa/A0001796.html
Then look up the long and lat for each of your choices with a vlookup.
Then use pythagorus to work out the diagonal distance between them.
If cell D1 has the 'longtitude' difference (one minus the other), and
D2 has the 'latitude' difference, then the formula to put in C1 is:
=sqrt((D1*D1)+(D2*D2))

As to how to convert these figures to miles. Look online and find an
established distance. Then divide your number by this number to get
the constant ratio.

 

[Ewing25]

I have a worksheet named Miles. I also have a Userform that asks the user
for Start Location and End Location then what i want it to do is have it
query google maps for specific miles and import that finding into cell C2
then if they press New Location (Commandbutton1) it resets the form and puts
the new data in C3.

Any Idea how to do that?