On Excel 2010, is there a way to add a link to Google Maps, based on the post code entered?

At the company I work for, we do deliveries, and I was wondering if there's a way for the spreadsheet to send the postcode data over to Google Maps so a sheet can be printed off for the van? Obviously it'll be a different postcode entered each time.



I am familiar with most formulas and macros so will be able to follow any directions fine.On Excel 2010, is there a way to add a link to Google Maps, based on the post code entered?
As long as you know how to link to a page dynamically, it's little problem. Use the service to search for a web page, and then reverse engineer the address. It may be obscured a little and contain unnecessary parts, but Google and Bing can be searched using http://maps.google.co.uk/maps?q=SW1A+1AA and http://www.bing.com/maps/default.aspx?wh鈥?/a>

Yahoo hides parts of URLs, so look at where those links actually point.

So in both cases its a prefix plus the post code with the space replaced by a +.

Excel gains some mapping functions if you install Microsoft MapPoint, it may also do the same if you install Microsoft AutoRoute (the consumer version).

makeup hair tips