You'll need a 3rd party add-in like PC Miler or maybe
Microsoft MapPoint to generate distances.

Chip Pearson does have a workbook on his site that you
can download. It calculates distance between 1200
different cities based on long/lat.

http://www.cpearson.com/excel/latlong.htm

HTH
Jason
Atlanta, GA

-----Original Message-----
I WORK WITH DISTANCES FROM CITY TO CITYS IN THE US.
ALMOST ALL ARE
REPETITIVE, BUT THE DESTINATIONS CHANGE DAILY. IS THERE
A TOOL, OR WIZARD
THAT CAN CRANK THESE OUT LIKE THE FORMULA BAR? IN OTHER
WORDS I GET 125
DESTINATIONS FROM ROCK ISLAND, IL, AND ANOTHER 87
DESTINATIONS FROM SHELL
ROCK, IA. THESE COME IN VIA E-MAIL IN EXCEL FORMAT,
COLUMN A IS
ORIGINATION CITY, COLUMN B IS STATE ABREVIATION. COLUMN
D IS DESTINATION
CITY, COLUMN E IS STATE ABREVIATION. IS THER A WAS OF
READING IF A, B AND C,
D THEN FIND FIGURE FROM MILEAGE TABLE?
.