creating a link from a set location to a location specified in another cell (googlemaps)

dear forum

I would like to create a link to google maps that directly opens directions between two locations.

The base location should remain the same (a UK postcode, e.g. n23 e1j) but should calculate directions by referencing an address in a second cell (again, given as a UK postcode).

I imagine this will default to driving directions, but if at all possible it would be a big bonus to repeat the link with a change in transport mode, so I could directly open google directions with the transit/bicycle options already selected.

nb.
I have already successfully linked to a google map to a location specified in a cell by following steps in someone else's post (as follows). So this is really a follow-on from that discussion. thank you.

http://www.excelforum.com/excel-form...readsheet.html

Tom

EDIT: (30 mins later)
I have reviewed numerous threads on this and youtube uploads. For anyone interested here's a youtube demo of how to create a link to directions: https://www.youtube.com/watch?v=tfFrwK8ezQc

I haven't yet found any way to set this to Bicycling or Transit modes, however, and this would still be extremely helpful if someone knows.
thanks

Here's how I've done it.
In A1 to A3, I have 'Postcode From', 'Postcode to' and 'Mode of Travel'.
I put the 'from' postcode into B1 and 'to' postcode in B2. Then I put a table in A6:B10 containing the following, for modes of transport:

Please Login or Register  to view this content.

In B3, I set up Data Validation to give a drop-down list of 'Driving / Cycling / Walking / Public Transport / Flying' - i.e. from A6:A10.

Then I use this formula to give me the link to Google maps:

Formula:

Please Login or Register  to view this content.

Now you can select your mode of transport and the link will give you what you choose.

You can add a 'via' by adding another cell and adding another "&SUBSTITUTE(B1," ","")&"/" section to the formula, e.g. this would work with the 'from' in B13, 'via' in B14, 'to' in B15 and 'mode' in B16:
=HYPERLINK("https://www.google.co.uk/maps/dir/"&SUBSTITUTE(B13," ","")&"/"&SUBSTITUTE(B14," ","")&"/"&SUBSTITUTE(B15," ","")&"/"&VLOOKUP(B16,$A$6:$B$10,2,FALSE))
If the 'via' is blank, Google will ignore it.

I've attached a file with the above working. Hope that helps.

Ok. With 'Postcode from' in B1, 'via' in B2 and 'to' in B3 (as noted above, if the 'via' is blank, Google will ignore it), use the following:

Driving

Formula:

Please Login or Register  to view this content.

Cycling

Formula:

Please Login or Register  to view this content.

Walking

Formula:

Please Login or Register  to view this content.

Public Transport

Formula:

Please Login or Register  to view this content.

Flying

Formula:

Please Login or Register  to view this content.

If you want the link to have a 'friendly name' just put that before the last bracket, like this:

Formula:

Please Login or Register  to view this content.

The attached sheet shows these working - in rows rather than the columns you asked for, but that's just so you can see the links more easily - you can move them around as you wish.
Hope that does what you want.

Glad to have helped - thanks for the feedback.

For future reference, if you copy a link formula from above into the formula bar instead of pasting it directly into a cell, it'll become clickable. If you paste it into a cell and it stays black & unclickable, then just go to the formula bar (click in it or press F2) then press Return to make it a proper hyperlink.

If that's your problem solved, please mark the thread as Solved to let others know that there's a solution here (instructions in my sig). Thanks.