Results 1 to 2 of 2

Thread: Combining and organizing 2 sheets with a common column

  1. #1

    Combining and organizing 2 sheets with a common column



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Here are the links for 2 sets of data. I could not attach them because they exceed the file limit.

    please click the download button. I believe you need to be logged into your Google Account to download.

    drive.google.com/folderview?id=0B19IVJ5jMd6LeXdLanNmSUgwcGs&usp=sharing (please copy and paste)

    both data sets have one column in common--API.

    I want to create a new sheet that will have combined data of both sheets, but only pertaining to API's that are common in both sheets. Book2 has fewer API's than Book1 does. However, not all the API's in Book2 are in Book1. I only want the API's that are common in both.

    Can anyone help with this?

    Thanks.

  2. #2
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    357
    Articles
    0
    Hi texas979. You can do this with VBA and SQL. If you know a bit of VBA, then this link might be enough to get you started. http://blog.contextures.com/archives...n-pivot-table/

    Otherwise, post back and I'll take a look.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •