Greetings all! It is great to become a member of your site.
My question is this:
The company I work for has over 600 locations, which I have mapped using MapPoint 2002. A client recently contacted us who has 1300 customer reps throughout the country, which I have also mapped. They would like to use our business services. To do this, we need to find our closest location to each of their closest reps.
Is there a way to do this? Currently, I locate one of their reps and find the closest facility to them. I then export both their information and our information for the closest location (in miles) into excel. I then copy and paste each export into a master excel sheet to provide the customer the closest facility for that particular rep and so on.
Isn't there an easier way that MapPoint can compare two variables (my business and my customers) to then tell me the closest location for each of their respective locations?
I do not care if we have a rep in Montana and the closest store for them is Chicago, IL. Or if it tells me we have 30 stores in Los Angeles and they have 150 representatives there. I just want to know of those 30 stores, which is the closest, in miles, to each of those reps. Only I want to do this nationwide without having to wast 25 hours doing this manually?
Thank you all so much in advance for this long post, but I really need all of your help!