+ Reply to Thread
Results 1 to 5 of 5

Calculate Distance Between Two Zip Codes

  1. #1
    Registered User
    Join Date
    07-23-2012
    Location
    Columbus, Ohio
    MS-Off Ver
    Excel 2003
    Posts
    2

    Calculate Distance Between Two Zip Codes

    I am very new to using Macros for Excel and I was wondering if there was a way to calculate the distance between two zip codes. The beginning zip code is in column A and the destination zip code is in column B. I know this question has been posted previously but I could not get those solutions to work for me.

    Thanks!

  2. #2
    Forum Contributor
    Join Date
    10-08-2010
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    386

    Re: Calculate Distance Between Two Zip Codes

    I would imagine for this to work you would need a large database full of information about each zip code. You would also need to create a marking system for each location, for it to compare with each other, because distance is relative.

  3. #3
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,187

    Re: Calculate Distance Between Two Zip Codes

    Have a look here:
    http://www.excelforum.com/tips-and-t...rivetimes.html

  4. #4
    Registered User
    Join Date
    07-23-2012
    Location
    Columbus, Ohio
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Calculate Distance Between Two Zip Codes

    Ah! Thank you very much! Your other thread solved my problem. I do not know how I did not stumble upon it in my initial search!

    Cheers!

  5. #5
    Registered User
    Join Date
    11-29-2012
    Location
    Chicago
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Calculate Distance Between Two Zip Codes

    Awesome Code. I have a sheet with over 6000 cells and it pretty slow to calculate all the cells. Once its done it a bit "buggy" and when I copy and paste values it just slower. Any ideas or tips to improve the speed?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1