Adding a Hyperlink to Maps to a Custom Report
Adding a Hyperlink to Maps to a Custom Report
It is sometimes useful to have a hyperlink in the Excel report that links to an external site directly. For example, if the report has the latitude and longitude available you can use the HYPERLINK function in Excel to create this link.
This is done as follows:
use the HYPERLINK function in a formula.
It takes two arguments, the first is the URL that it must point to, the second is what should be displayed to the user.A Google map link has this format: maps.google.com/maps?q=43.3,-79 where the q=43.3,-79 is the part where you specify the coordinate.
If you have the coordinate in the report as columns, you can easily create a link that follows the format specified above by referencing the relevant columns:
=HYPERLINK("http://maps.google.com/maps?q="&D2&","&E2,"See location")