Results 1 to 2 of 2

Thread: how can i calculate distances in mass for about 7000 records through entering postcodes!

  1. #1
    Join Date
    Aug 2012
    Posts
    1

    sad how can i calculate distances in mass for about 7000 records through entering postcodes!

    Need a small step by step guide, like what to download, what codes to put in (and where to put them in) and what formulas to use, all help will be much appreciated!!

  2. #2
    Join Date
    Dec 2007
    Posts
    2,297

    Re: how can i calculate distances in mass for about 7000 records through entering postcodes!

    If i understand you properly, then try to paste the below codes in the macro by pressing the window (Alt F8).

    Code:
    for a = 2 to 51
    cells(a,1) = 56000 + a - 1
    cells(1,a) = 56000 + a -1
    next a
    After that run the macro.

Similar Threads

  1. Replies: 6
    Last Post: 22-02-2012, 06:48 AM
  2. Replies: 7
    Last Post: 22-02-2012, 05:57 AM
  3. Distance Calculator between two UK postcodes in excel
    By AbiCgail in forum Software Development
    Replies: 10
    Last Post: 07-02-2012, 05:35 AM
  4. VX-7000 annoyance, need help.
    By Edbert in forum Portable Devices
    Replies: 3
    Last Post: 31-03-2011, 07:02 AM

Posting Permissions

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