<html><head><style> body {height: 100%; color:#000000; font-size:12pt; font-family:Times New Roman;}</style></head><body>Mark's technique does work. If you have three columns in your spreadsheet:<br>(A) Start Address (2711 South Loop Drive, Ames, IA)<br>(B) Destination Address (1007 East Grand Avenue, Des Moines, IA)<br>(C) Computed URL (=HYPERLINK("http://maps.google.com/maps?saddr="& A1&"&daddr=" & B1))<br><br>When you click on the URL, it should show you a google map from Beardshear Hall, ISU Campus, to the Capitol Building in Des Moines. One drawback for your requirement, google maps seems to follow roads...it won't show you a direct line or follow a buried cable.<br><br>----- Original Message -----<br>From: Dave Weis <djweis@internetsolver.com><br>To: 'cialug@cialug.org' <cialug@cialug.org><br>Sent: Fri, 20 Aug 2010 13:28:31 -0500 (CDT)<br>Subject: Re: [Cialug] Lazy programmer question<br><br><br>I might have been unclear the first time, I do want all the lines on one map. <br><br>I have a spreadsheet with the start and end of fiber optic lines but want a view of it because its a pain to create a route with cells. <br><br><br>----- Original Message -----<br>From: cialug-bounces@cialug.org <cialug-bounces@cialug.org><br>To: Central Iowa Linux Users Group <cialug@cialug.org><br>Sent: Fri Aug 20 13:33:00 2010<br>Subject: Re: [Cialug] Lazy programmer question<br><br>Toying around a little, it looks like you can use<br><br>http://maps.google.com/maps?saddr="start address here"&daddr="end address here"<br><br>as a URL to generate a map from the starting address to the ending<br>address. Combined with Matthew's suggestion for creating a URL using<br>cells, this should get you a column of links/addresses from which to<br>build maps.<br><br>-- <br>Mark Hesseltine<br>mailto:markhesseltine@gmail.com<br>_______________________________________________<br>Cialug mailing list<br>Cialug@cialug.org<br>http://cialug.org/mailman/listinfo/cialug<br>_______________________________________________<br>Cialug mailing list<br>Cialug@cialug.org<br>http://cialug.org/mailman/listinfo/cialug<br><br></cialug@cialug.org></cialug-bounces@cialug.org></cialug@cialug.org></djweis@internetsolver.com></body></html>