+ Reply to Thread
Results 1 to 10 of 10

Vlookup and copy data back into original data

  1. #1
    Registered User
    Join Date
    02-20-2011
    Location
    Dublin
    MS-Off Ver
    Excel 2007
    Posts
    88

    Vlookup and copy data back into original data

    Hi Guys,

    I have some script that copies data from an original sheet "Details" into 5 separate sheets depending on some logic ( e.g. A value > 7 and P = "").

    but when I update the data on these separate tab I need to be able to copy some details back into the original data.

    E.g.

    "Details" Table :
    ID Read
    001 1234
    002 4567

    Copied to the "Readings" Table where I change the read data:
    ID Read
    001 1111
    002 2222

    And then I need to run a macro that looks up the ID from the "readings" table in the "details" table
    And updates the Read from the "readings" table back into the "details" table

    "Details" Table now needs to look like this :
    ID Read
    001 1111
    002 2222


    I have the copy done so I just need some assistance with the copy back if possible please ?

    Thanks
    Sarah

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Vlookup and copy data back into original data

    Which columns are the ID and Read for each sheet?

  3. #3
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,558

    Re: Vlookup and copy data back into original data

    Quote Originally Posted by Sazza View Post

    I have some script...
    If you want help with modifying your script, perhaps you should post your script.

    An example workbook would be useful to. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  4. #4
    Registered User
    Join Date
    02-20-2011
    Location
    Dublin
    MS-Off Ver
    Excel 2007
    Posts
    88

    Re: Vlookup and copy data back into original data

    @ JOHN H. DAVIS - the "ID" is column B and the "read" is in G

  5. #5
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Vlookup and copy data back into original data

    Maybe:

    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    02-20-2011
    Location
    Dublin
    MS-Off Ver
    Excel 2007
    Posts
    88

    Re: Vlookup and copy data back into original data

    @ AlphaFrog - Please see attached
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    02-20-2011
    Location
    Dublin
    MS-Off Ver
    Excel 2007
    Posts
    88

    Re: Vlookup and copy data back into original data

    Thanks John ... I'm get an object required compile error on this line ?

    Please Login or Register  to view this content.

  8. #8
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Vlookup and copy data back into original data

    My mistake:

    Please Login or Register  to view this content.

  9. #9
    Registered User
    Join Date
    02-20-2011
    Location
    Dublin
    MS-Off Ver
    Excel 2007
    Posts
    88

    Re: Vlookup and copy data back into original data

    That perfect - Thank you very very much for your help ....

  10. #10
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Vlookup and copy data back into original data

    You're welcome. Glad to help out and thanks for the feedback and the reps. Please mark this thread as SOLVED.

+ 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. Copying lots of data into a calculator and listing results back with original data
    By Davexcelhelp in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-15-2015, 05:29 AM
  2. what i do to get back to original data ?
    By mokht in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-28-2015, 05:04 PM
  3. Replies: 1
    Last Post: 11-26-2014, 04:28 AM
  4. Help: Reset input data back to original
    By jasonj427 in forum Excel General
    Replies: 5
    Last Post: 01-22-2013, 01:49 AM
  5. Replies: 3
    Last Post: 12-20-2012, 06:16 AM
  6. Replies: 1
    Last Post: 04-01-2006, 03:50 PM
  7. Pivot Tables - Can I get back to my original Data
    By Markl in forum Excel General
    Replies: 2
    Last Post: 02-28-2006, 10:01 AM

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