+ Reply to Thread
Results 1 to 3 of 3

Help with combining data on different sheets

  1. #1
    Registered User
    Join Date
    04-22-2015
    Location
    Austin, TX
    MS-Off Ver
    2010
    Posts
    30

    Help with combining data on different sheets

    I have the attached workbook I need to find out how to merge the data together. There are 2 different reports Sheet1 and Sheet2 both correspond to each other with a case number, but I need to add the information from sheet2 to sheet1. These are just samples, the headers and columns will remain the same but I had to scrub data on these. I have about 2300 cases and trying to manually merge these is going to take way longer then I have to get it done. Is there a macro or formula I can use to move the data from sheet2 to the corresponding cases on sheet1?
    Attached Files Attached Files

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

    Re: Help with combining data on different sheets

    You can use a simple VLOOKUP.

    G4: =VLOOKUP($B4, Sheet2!$A:$H, 2, 0)
    H4: =VLOOKUP($B4, Sheet2!$A:$H, 3, 0)
    I4: =VLOOKUP($B4, Sheet2!$A:$H, 4, 0)

    Etc...

    You'll need to format the date cells to display in date format. Then copy G4:M4 down to get all the result.
    _________________
    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
    04-22-2015
    Location
    Austin, TX
    MS-Off Ver
    2010
    Posts
    30

    Re: Help with combining data on different sheets

    That was easier than I was expecting... Thank you very much!

+ 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. Combining data from two sheets
    By Ankka in forum Excel General
    Replies: 1
    Last Post: 05-23-2014, 02:10 PM
  2. Need help with combining Data from 2 sheets
    By Conradforbis in forum Excel General
    Replies: 3
    Last Post: 03-23-2012, 02:43 PM
  3. Need Combining data from two sheets
    By GirlFromOz in forum Excel - New Users/Basics
    Replies: 11
    Last Post: 03-10-2007, 05:31 PM
  4. Combining data from two sheets
    By sparren in forum Excel General
    Replies: 7
    Last Post: 02-10-2007, 03:59 PM
  5. help with combining data from 2 sheets
    By unclegar95 in forum Excel General
    Replies: 2
    Last Post: 10-11-2006, 06:16 AM
  6. Combining Data from multiple sheets...
    By FogCat in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-16-2006, 11:35 AM
  7. Combining data from different sheets in one
    By viktor in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 07-07-2005, 05:47 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