Mileage Dilema

[Watchdawg]

I have a nephew that plays different country music gigs. He wasn't aware that he could claim the mileage on his truck to the IRS. There's no chance that I can get him to remember to write down his starting and ending mileage for each gig, but he posts all of his locations. What I need is a userform that asks him his starting address and his ending address. That should paste into a spreadsheet in B2 and C2 (unless those are populated, then the next available cell) and calculate the mileage between the two locations. I've seen a few answers but none of them have worked. Can any of the guru's on here help me out? I use Google Chrome for the browser and the map information could come from google maps, mapquest, wherever.

Thanks!

 

[mumps]

Have a look at this link: https://analystcave.com/excel-calculate-distances-between-addresses/

 

[Watchdawg]

Have a look at this link: https://analystcave.com/excel-calculate-distances-between-addresses/

Thank you. I looked at that one. I must be doing something wrong, I wasn't able to get it to work for me.

 

[mumps]

Click here to download a test file. Just click the "Get Distance" button and follow the instructions. You may need to have Internet Explorer on your machine.