Google Sheet to Populate Driving Distance Between two Google Maps Locations
Budget: $30 – $250 USD
I need to be able to calculate the driving distance & time between two known google maps locations & have it automatically populate in Google Sheets.
It should work something like this..
Cell A1 "Job Name" Cell A2 "Job Location" (Lat Long or Pin Location from Google Maps)
Cells A2:A200 "Supplier Names" Approximately 200
Cells B2:B200 "Supplier Locations" either street address or lat long from google maps
Cells C2:C200 Populate distance in miles between supplier location & job
Cells D2:D200 Populate drive time between supplier and location & job
User should have the ability to sort data by miles or drive time
It should work something like this..
Cell A1 "Job Name" Cell A2 "Job Location" (Lat Long or Pin Location from Google Maps)
Cells A2:A200 "Supplier Names" Approximately 200
Cells B2:B200 "Supplier Locations" either street address or lat long from google maps
Cells C2:C200 Populate distance in miles between supplier location & job
Cells D2:D200 Populate drive time between supplier and location & job
User should have the ability to sort data by miles or drive time