2 Replies Latest reply on Feb 6, 2014 8:00 AM by Matt Lutton

    Custom geocoding, calculating distances

    Brian Scicluna


      I have this scenario where I have an Excel workbook with two sheets.


      Sheet 1 is called Restaurants and it contains Restaurant Name, Longitude, Latitude as below




      Sheet 2 is called customers and it contains Customer Name, Longitude, Latitude as below



      I would like to do the following:


      a. Get all data from both sheets (even though there is no relationship)

      b. Subsequently plot all customers and restaurants on map

      c. Use custom shapes to determine which are the customers and which are the restaurants

      d. Probably the most difficult.... upon selecting a customer I want to determine distances to each restaurant!


      Is this possible? Your help is gladly welcome at this stage!