View Single Post
  #3   Report Post  
Excel_Geek
 
Posts: n/a
Default


Once the addresses have been imported and are visible on the map, click
and drag to select all of the data points and right click. Select "add
pushpins as stops". This will add each address as a stop on the Route
Planner tool. Then view the Route Planner tool -- click the little red
car. At the bottom of that tool is an "Optimize Stops" function.

This function can take awhile depending upon the number and locations
of the addresses you wish to optimize.

Oh, and you'll want to be sure to select your own Start and End (first
and last addresses).

Hope this helps.


--
Excel_Geek
------------------------------------------------------------------------
Excel_Geek's Profile: http://www.excelforum.com/member.php...o&userid=26423
View this thread: http://www.excelforum.com/showthread...hreadid=396877