+ Reply to Thread
Results 1 to 7 of 7

Combine data from multiple workbooks into one worksheet based on condition

  1. #1
    Registered User
    Join Date
    08-03-2011
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    7

    Combine data from multiple workbooks into one worksheet based on condition

    I have a list of leads that have everything but the phone number and then a list with everything.
    List A (lista.csv) has Name, Street, City, Zip, Age
    List B (listb.csv) has Phone Number,Name, Street, City, Zip

    what I want to have is
    List C (listc.csv) Phone Number,Name, Street, City, Zip, Age

    so I need a vba or method to have workbook C open List A and scan through list B to match Street & Name and if those two conditions match to take the phone number data from list b and add it to the correct record from list A and save it as List C.

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Combine data from multiple workbooks into one worksheet based on condition

    Hi udfxrookie007,

    You can use lookup formulas (Vlookup, Index / Offset & Match etc) to achieve the desired result.
    Post a sample workbook if you face any challenges. thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

  3. #3
    Registered User
    Join Date
    08-03-2011
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Combine data from multiple workbooks into one worksheet based on condition

    Biggest problem I face is that the lists are HUGE, List A is the list of 1.2 million leads that I need to add phone numbers to, and List B is a list of ALL the residents in a state with their phone numbers.... Working in excel... honestly I don't know how to even compare two files... or for me to create a List C that pulls data from List A and List B (let alone compares them on conditional rules)

  4. #4
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Combine data from multiple workbooks into one worksheet based on condition

    Post a sample workbook with just 100 rows.. if that suits. thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>

  5. #5
    Registered User
    Join Date
    08-03-2011
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Combine data from multiple workbooks into one worksheet based on condition

    e-mail sent

  6. #6
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Combine data from multiple workbooks into one worksheet based on condition

    Hi udfxrookie007,

    Please upload the file here, click on "Go Advanced" while replying to this post and look for paper clip icon to upload a sample file. thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>

  7. #7
    Registered User
    Join Date
    08-03-2011
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Combine data from multiple workbooks into one worksheet based on condition

    Unfortunately I cannot post live data on the web, the samples were e-mailed to you if you'd like to give it a shot. If not I have a programmer here that is also trying it by creating a database...

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1