Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: compare 2 spreadsheets and create 3rd unique

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I was wondering how to go about the following:

    I have 2 spreadsheets.
    They both contain columns for part numbers, along with several other columns that are unique to each spreadsheet.
    I would like to compare the two 'part number' columns and bring all the columns of data into another spreadsheet omitting any duplicate part numbers.

    I would appreciate any help.

    Thank you

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    255
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Is there one column of part numbers that don't repeat and one with part numbers that repeat? How much data is there? It's not that hard to write code to do such a thing but it may take a while to run if there is a large amount of data.

    Dave

  3. #3
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    MS Query can do this quite easily. See this excellent tutorial for more info.

    http://tushar-mehta.com/index.html?h...cel/intro.html

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    255
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    What is MS Query? Another program or part of excel?

  5. #5
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    MS Query is an Add-In avalable with Office Go to Tools Add-ins to activate it. If it does not appear as an add-in, you will have to re-install MS Office.

  6. #6
    New Member
    Join Date
    Mar 2002
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-26 10:14, davers5 wrote:
    Is there one column of part numbers that don't repeat and one with part numbers that repeat? How much data is there? It's not that hard to write code to do such a thing but it may take a while to run if there is a large amount of data.

    Dave
    Dave,
    On spreadsheet 1, there are 4 columns;
    part number, description, internal code and price

    On spreadsheet2, there are 6 columns; part number, description and 4 others (these 4 do not match the other columns on Spreadsheet1).

    The part number columns may have identical numbers, and the corresponding description columns may be different.

    I would like to create a 3rd spreadsheet that incorporates all 9 columns, ommitting any duplictae part numbers.

    The data is only about 500 lines each.

    Thanks

  7. #7
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi
    No problem
    Will need:
    Name of sheet1 with part numbers
    Beginning Row of Data
    Column PartNum
    Column Description
    Column Internal Code
    Column Price

    Name of sheet2 with part numbers
    Column PartNumbers
    Column Description
    Col 3,4,5,6

    Name of sheet3 to place combined data

    You said that the part numbers may match, but the descriptions may be different?
    Seeing that one of the entries will be disreguarded because of matching Part Numbers, does it matter which one?

    Are they to be sorted by Part Number, Description, Internal code???

    Please Reply or send the workbook to:
    TsTom@hotmail.com

    Tom


Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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