+ Reply to Thread
Results 1 to 3 of 3

combining two excel worksheet into one

  1. #1
    Registered User
    Join Date
    05-01-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    1

    combining two excel worksheet into one

    Hi,

    I need help to combine two excel worksheet into one new worksheet. thing is on both of these worksheet doesnt have a unique identifier. Is that possible & how.

    Thanks.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,116

    Re: combining two excel worksheet into one

    Hi and welcome to the forum

    Without seeing a sample of what you are working with, its almost impossible to give you an answer.

    i would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that
    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Valued Forum Contributor Lemice's Avatar
    Join Date
    04-13-2013
    Location
    Somewhere.
    MS-Off Ver
    Excel 2016
    Posts
    696

    Re: combining two excel worksheet into one

    Hello,

    First, short answer is yes, you can use the combo INDEX MATCH and COUNTIF to create another worksheet that will auto-populate itself with unique value from two other worksheets.

    The long answer is, however, as FDibbins suggested, please upload a small sample file with dummy data so we have a hold your layout, what you want to achieve, your expected results, etc.

    On post #2 FDibbins has given you an instruction of how to upload a sample file. He wrote it with a lot of details, and you should definitely be able to do it.
    (copy pasta from Ford)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools

    Regards,
    Lem

+ 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