Results 1 to 5 of 5

Copying lots of data into a calculator and listing results back with original data

Threaded View

  1. #1
    Registered User
    Join Date
    07-23-2015
    Location
    UK
    MS-Off Ver
    2007
    Posts
    5

    Copying lots of data into a calculator and listing results back with original data

    Morning all,
    I have a spreadsheet calculator that is unfortunately protected that returns a number when a postcode is entered.
    I also have a huge list of postcodes that I need to run through this calculator and record the numbers returned.

    Any ideas how best to copy the postcodes across to the calculator and then copy the resulting number back to my postcode list in one go? If not i may lose the will to carry on with the next 5000 postcodes!

    thanks in advance for any help offered.
    Last edited by Davexcelhelp; 10-15-2015 at 05:01 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. macro to do a lookup and sum
    By Shellybelly in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-23-2015, 08:30 AM
  2. [SOLVED] Macro for lookup
    By WillemB in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-24-2014, 11:26 AM
  3. how can we use macro in v lookup ?
    By Mansiha dixit in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-30-2013, 02:19 PM
  4. lookup macro help
    By mm5384 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-12-2012, 10:29 AM
  5. lookup macro, solver macro, realtime macro
    By xelhelp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-02-2011, 06:14 PM
  6. Lookup or Macro ? - Not sure which is best?
    By conks in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-06-2008, 10:54 AM
  7. Macro lookup
    By dudemango in forum Excel General
    Replies: 6
    Last Post: 02-06-2006, 05:20 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