PDA

View Full Version : Excel VBA for Longtitude and Latitude Help Please!!!



Mastermind4r
04-19-2012, 12:55 PM
I am new to Vba and I am trying to solve this longtitude and latitude problem. I am going to try and explain it to the best of my abilities. I have list of 20 stores with longs and lats and I have a list of 20 competitors with longs and lats. I'm trying to write a vba code that when ran, it will return how many of my stores is within 2 miles, 5 miles, and 10 miles and will also return how many of the competitors stores are within 2 miles, 5 miles, and 10 miles. Please see the attached image for further explanation..

Thanks in advance to whomever response!!!

Kenneth Hobs
04-19-2012, 02:53 PM
Welcome to the forum! See: http://www.cpearson.com/excel/LatLong.aspx

Paul_Hossler
04-19-2012, 03:05 PM
is within 2 miles, 5 miles, and 10 miles and will also return how many of the competitors stores are within 2 miles, 5 miles, and 10 miles


Within x miles of what lat-long?

Paul