I'm struggling with a mind-numbing task that needs immediate automation. While we're looking for cheap alternatives to employ for automating kilometer calculation from point A to point B, I thought it's best to inquire the forum what are the possible options to 1) create a hyperlink for each lane (Point A to Point B) in order to populate and 2) extract all the values from the hyperlink straight into the spreadsheet without clicking every single hyperlink to extract the distance in kilometers.

Every day, we receive more than 500+ lanes to evaluate and calculate their distance, and it got to the point where it's incredibly mind numbing for the whole team to spend 1/2 of the work day trying to add the kilometers from google maps onto the excel spreadsheet.

Any tips will be greatly appreciated!

Best

Foxozaur