+ Reply to Thread
Results 1 to 5 of 5

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

  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.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,592

    Re: Macro? Lookup?

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

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

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

    Sorry zbor. Now corrected.

    Dave

  4. #4
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,592

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

    Just a note to all:

    Since we a speaking here about PROTECTED calculator any solution with implifying breaking up security will end with closing thread and infraction to participants.

    Only solutions that doesn't bypassing security will be allowed.

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

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

    Thanks Zbor,
    You are right. The only upside is I have 1 sheet that is unprotected which is the one with the list of postcodes on so we can play with that sheet.

+ 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. 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