Excel VBA for Longtitude and Latitude Help Please!!!

[Mastermind4r]

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]

Welcome to the forum! See: http://www.cpearson.com/excel/LatLong.aspx

[Paul_Hossler]

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