View Full Version : The order in which data is exported to excel
lovetann
03-25-2008, 07:51 AM
Say that I have three pushpins in my map. If I select these, right-click and export to excel, - in which order will they appear in the worksheet? It seems rather random to me...
Mattys Consulting
03-25-2008, 10:58 AM
lovetann,
You're correct. It definately requires programming to obtain ordering.
Mike Mattys
Eric Frost
03-25-2008, 11:17 AM
Luckily, Excel has some options to sort data. :pimp:
Eric
Winwaed
03-26-2008, 08:02 AM
The question is: What order should the data be in? MapPoint doesn't know. As Eric says: Use Excel to sort on which ever data field you want.
If you used the pushpins to create waypoints, then we have a product which will sort them in route order: RouteWriter, see:
http://www.routewriter.com
Richard
Powered by vBulletin® Version 4.2.0 Copyright © 2013 vBulletin Solutions, Inc. All rights reserved.
Search Engine Friendly URLs by
vBSEO 3.6.1