Hello everyone,
First, I'd like to thanks Chandoo because I've found a great and also very simple file to calculate the distances and time with Google Maps in Excel.
I'm trying to improve this file tu be used tu calculate every distance that come in a table when I recieve a Reservation. Unfortunately, my knowledge about excel isn't great with advanced formula and VBA is out of range right now..
I'm trying to make this file with the same logic as Chandoo's file. What I d'like is, when a reservation come, is to calculate the distance and travel time between the adresses who are in the columns M and N.
I have the feeling that it's not that complicated, but I'm stuck on this..
If anyone can give me some advice, I can reward him with a Beer or any other drink (from any online shop!)
Thanks in advance
First, I'd like to thanks Chandoo because I've found a great and also very simple file to calculate the distances and time with Google Maps in Excel.
I'm trying to improve this file tu be used tu calculate every distance that come in a table when I recieve a Reservation. Unfortunately, my knowledge about excel isn't great with advanced formula and VBA is out of range right now..
I'm trying to make this file with the same logic as Chandoo's file. What I d'like is, when a reservation come, is to calculate the distance and travel time between the adresses who are in the columns M and N.
I have the feeling that it's not that complicated, but I'm stuck on this..
If anyone can give me some advice, I can reward him with a Beer or any other drink (from any online shop!)
Thanks in advance
Attachments

10.4 KB Views: 4