M
Mastermind4real
I am new to Vba and I am trying to solve this longtitude and latitud
problem. I am going to try and explain it to the best of my abilities.
have list of 20 stores with longs and lats and I have a list of 2
competitors with longs and lats. I'm trying to write a vba code tha
when ran, it will return how many of my stores is within 2 miles,
miles, and 10 miles and will also return how many of the competitor
stores are within 2 miles, 5 miles, and 10 miles. Please see th
attached image for further explanation..
Thanks in advance to whomever response!!
+-------------------------------------------------------------------
|Filename: Capture.JPG
|Download: http://www.excelbanter.com/attachment.php?attachmentid=334
+-------------------------------------------------------------------
problem. I am going to try and explain it to the best of my abilities.
have list of 20 stores with longs and lats and I have a list of 2
competitors with longs and lats. I'm trying to write a vba code tha
when ran, it will return how many of my stores is within 2 miles,
miles, and 10 miles and will also return how many of the competitor
stores are within 2 miles, 5 miles, and 10 miles. Please see th
attached image for further explanation..
Thanks in advance to whomever response!!
+-------------------------------------------------------------------
|Filename: Capture.JPG
|Download: http://www.excelbanter.com/attachment.php?attachmentid=334
+-------------------------------------------------------------------