+ Reply to Thread
Results 1 to 4 of 4

Match Data from Another Sheet and Transfer Values

  1. #1
    Registered User
    Join Date
    08-19-2013
    Location
    New York, NY
    MS-Off Ver
    Excel 2003
    Posts
    77

    Match Data from Another Sheet and Transfer Values

    Hello everybody, I believe I have a fairly simple macro that I need some help on. I will be starting in Cell I2 on the import Sheet. IN Column B i have File Numbers that I need to match up with Column B in the master sheet. When the file numbers match it will pull the information on that row from Columns F,G,H and paste it in Columns I,J,K on the Import Sheet. This macro will continue until there are no more values to try and match from Column B on the Import Sheet. Thanks for your help.
    Test.xlsx

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Match Data from Another Sheet and Transfer Values

    Not really a macro thing.

    IMport Sheet:

    I2: =VLOOKUP($B2, Master!$B:$H, 5, 0)
    J2: =VLOOKUP($B2, Master!$B:$H, 6, 0)
    K2: =VLOOKUP($B2, Master!$B:$H, 7, 0)

    Now copy those three cells down.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    “None of us is as good as all of us” - Ray Kroc
    “Actually, I *am* a rocket scientist.” - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    08-19-2013
    Location
    New York, NY
    MS-Off Ver
    Excel 2003
    Posts
    77

    Re: Match Data from Another Sheet and Transfer Values

    How can I make it a macro because I'm making this for users to use by pushing a button. Thanks for your help.

  4. #4
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Match Data from Another Sheet and Transfer Values

    Ever used the macro recorder? It's a great way to get basic code for simple functions that will be repeated.

    Please Login or Register  to view this content.

+ 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. Replies: 2
    Last Post: 11-21-2013, 10:01 AM
  2. [SOLVED] Match between 2 sheets, highlight and transfer to new sheet
    By Narasimharao Nandula in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 08-28-2013, 09:51 PM
  3. Replies: 1
    Last Post: 03-11-2013, 05:37 AM
  4. [SOLVED] Macro to transfer data as values to another sheet based on the result from a formula
    By bpiroma in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-19-2012, 07:22 AM
  5. [SOLVED] Match or Loop to Transfer Data from Userform to Sheet
    By cschoyer in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-25-2012, 03:06 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