Can't read the picture - resolution too small...


CE



Den 19.04.2012 22:13, Mastermind4real skrev:
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!!!


+-------------------------------------------------------------------+
|Filename: Capture.JPG |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=334|
+-------------------------------------------------------------------+