I need some advice, I have read and downloaded the template from this guide:
Calculate travel time and distance between two addresses using Excel + Maps API (chandoo.org)
I have it working great using my Bing API and calculating distance and travel time accurately. What I can figure out is how to get this working for multple postcodes with a table.
To give you and example I'm using excel as part of a vehicle route planner. Each job is on a new line in excel will all the information required, when I enter the customer postcode I would like the next two cells to automatically populate with the distance and time for that job
Any help is appreciated
Calculate travel time and distance between two addresses using Excel + Maps API (chandoo.org)
I have it working great using my Bing API and calculating distance and travel time accurately. What I can figure out is how to get this working for multple postcodes with a table.
To give you and example I'm using excel as part of a vehicle route planner. Each job is on a new line in excel will all the information required, when I enter the customer postcode I would like the next two cells to automatically populate with the distance and time for that job
Any help is appreciated