+ Reply to Thread
Results 1 to 3 of 3

copy matched data between worksheets

  1. 07-13-2010, 09:48 AM #1
    stb
    stb is offline
    Registered User
    Join Date
    07-13-2010
    Location
    London, England
    MS-Off Ver
    Excel 2013
    Posts
    20

    copy matched data between worksheets

    Hello everyone, my first posting here (and I truly hope I have searched the forum hard enough to NOT replicate a request)

    I have two worksheets (see attachment), one is a template, the other contains live data. I need to fill in the empty column in the template worksheet with data from the "live data" worksheet.
    "Live data" contains column "Identifier" which is the only unique piece of information to match the equivalent on "template". To complicate things, each person on the "template" is only listed once, while on "live data" each person can be listed several times and amounts need to be added up before being entered into "template".

    Clear as mud? I hope not and thanks in advance.
    Attached Files Attached Files
    Last edited by NBVC; 07-13-2010 at 11:25 AM. Reason: Solved Per Rep Remarks.
    Reply With QuoteRegister To Reply
  2. 07-13-2010, 10:30 AM #2
    NBVC
    NBVC is offline
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: copy matched data between worksheets

    Try:

    =SUMIF('live data'!C:C,E2,'live data'!E:E)

    copied down.
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
    Reply With QuoteRegister To Reply
  3. 07-13-2010, 11:27 AM #3
    stb
    stb is offline
    Registered User
    Join Date
    07-13-2010
    Location
    London, England
    MS-Off Ver
    Excel 2013
    Posts
    20

    Re: copy matched data between worksheets

    Thank you, it does exactly what I wanted it to do. I wish I had consulted this forum a little earlier.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1