I have a spreadsheet with addresses. It is broken down into standard columns such as name, Address, City, State and Zip code. I need to be able to quickly determine the distance in miles from a reference zip code to every zip code in the spreadsheet. I need the output to be placed on another column right next to every zip code in the spreadsheet. I need this to be a tool. We don't want someone to do this for us. We are asking for someone that can put together a small solution to accomplish this.
Hi, I can provide a solution in Excel which will allow you to get distances between the reference zipcode and the zipcodes for each record. Please check your messages. Thanks
Hi tdg2k8 ,
I have already created a tool built in Excel to find distance between two two U.S. or Canadian ZIP codes.
I have attached the file.
Please try it
Best Regards,
Naveen
Easy, two steps job:
1/ create a macro that retrieves lat and long from google maps for any new address in your spreadsheet
2/ calculate automatically relative distances to the other adresses in the sheet.
Durable solution and reusable at will :)
I can do that for you in a short timeframe, possibly in one days.