Microsoft Excel- Plotting Lines onto Google Maps (Macro)

Just an FYI-I am a first time Macro user, but I am otherwise well versed in Excel logic and formula use.

I am trying to create a Macro that plots lines onto Google Maps based on the following:

Customer A:

Coordinates of ship from location

Coordinates of ship to location

R (2 for destination, 1 for supplier)
Customer B:

Coordinates of ship from location

Coordinates of ship to location

R (2 for destination, 1 for supplier)

And so on, and so on. This does not need to be exact, but it is an approximation to show what the most cost effective routes will be.
I have a coworker that had a macro that did this, so I know it is possible. However, he says it is not very user friendly, so I will not have access to it. He says all he uses is Google Maps and Excel. Any tips you have for creating this macro would be highly appreciated! I am open to purchasing add-ons under $100, if it will help.

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.