+ Reply to Thread
Results 1 to 4 of 4

Distances between postcodes (please read post for more info)

  1. #1
    Registered User
    Join Date
    09-19-2014
    Location
    England
    MS-Off Ver
    2007
    Posts
    2

    Distances between postcodes (please read post for more info)

    Hello,

    So at the company I work for we use a few scaffold companies and I'm wondering if there's anyway that if I enter a random postcode (UK) it would work out the mileage between each company and then come back with who the cheapest is (this part I know I could maybe use a VLOOKUP formula to work out but working out the mileage I have no clue). I've looked on previous posts and I just can't seem to get it working.

    I'm using Excel 2007 hope you guys can help me!

    Thank you. - If you need any more details just ask.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,065

    Re: Distances between postcodes (please read post for more info)

    The postcode won't tell you how far away an address is.
    Prob be better to use Google maps and get that to do it for you.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    09-19-2014
    Location
    England
    MS-Off Ver
    2007
    Posts
    2

    Re: Distances between postcodes (please read post for more info)

    How would I go about getting the distances then if I may ask? I want to get away from avoiding Google maps and just try implement it on 1 spreadsheet with all the prices and stuff, trying to improve efficiency haha.
    Last edited by azah678; 09-19-2014 at 05:23 AM.

  4. #4
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,065

    Re: Distances between postcodes (please read post for more info)

    You'd have to ask Google that. I've no idea where they get the distances from.
    A spreadsheet would be better but if you're just dealing with "a few scaffolding companies" you're better off doing it manually.
    It depends how many "a few" is.

  5. #5
    Registered User
    Join Date
    09-19-2014
    Location
    England
    MS-Off Ver
    2007
    Posts
    2

    Re: Distances between postcodes (please read post for more info)

    Around 20 which is a bit more than a few haha. Reason I want this is because on our computers google maps is really slow and it can take 5-8minutes to get the distances between 3 companies and then the pricing, was hoping if I could implement all that together into a spreadsheet or something it would decrease the time it takes to do the above.

    Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculating Google Maps Distances Using Postcodes
    By smart_as in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 05-14-2021, 03:08 PM
  2. Measuring Distances between Postcodes (Mark 2)
    By Woozer74 in forum Excel General
    Replies: 0
    Last Post: 12-15-2011, 04:56 PM
  3. Have Userform read info from another sheet.
    By ilovelagar in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-10-2009, 03:17 PM
  4. Replies: 3
    Last Post: 02-12-2008, 06:11 AM
  5. [SOLVED] i need info from the top workbook to be read in multiple workbooks
    By sfsddiamond in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-09-2005, 12:45 PM

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