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!!!