Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



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

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 17-08-2012
Member
 
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!!

Reply With Quote
  #2  
Old 17-08-2012
Member
 
Join Date: Dec 2007
Posts: 2,268
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.
Reply With Quote
Reply

  TechArena Community > Software > Software Development


Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "how can i calculate distances in mass for about 7000 records through entering postcodes!"
Thread Thread Starter Forum Replies Last Post
Unable to play Mass Effect 2 after playing Mass Effect 3 demo Muthukumar Video Games 6 22-02-2012 07:48 AM
Is it possible to transfer Steam Mass Effect 2 save file into Origin Mass Effect 3 Farren Video Games 7 22-02-2012 06:57 AM
Distance Calculator between two UK postcodes in excel AbiCgail Software Development 10 07-02-2012 06:35 AM
VX-7000 annoyance, need help. Edbert Portable Devices 3 31-03-2011 08:02 AM


All times are GMT +5.5. The time now is 10:00 AM.