I do not have any experience with VBA's. I have the Bing Maps App installed on my computer, which I love and works perfectly for what I am trying to do. The problem, is that when I send these maps to who I am creating them for, no one has Bing Maps in their Excel, and the map shows up blank when they open it.

I have a template, with 31 tabs. One master tab contains all of the data points and contain address data. This tab populates all of the rest of the tabs with formulas based on certain criteria. These tabs will only have 5 to 50 rows of data. What I need, is an interactive map on each tab that can be updated with the data points if they are changed, creating pins for each location with the information popping up if you click on the pins as if it were in Google Maps.

I saw an example book where someone created two VBA's in one workbook, where the first one geocoded the data, and the second one brought in the interactive map from Google Maps. He only did it for one data point, and again, I have no experience with VBA's. I am thinking this would have to happen with something like that. I attached how my data will look at the bottom of this, and would be happy to send someone my template of 30 tabs if that would help as this is a very important project. Any Help would be greatly appreciated.

Thank you.

Excel Help.xlsx