compare 2 spreadsheets and create 3rd unique

Timehri · Mar 26th, 2002, 10:02 AM

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

davers5 · Mar 26th, 2002, 11:14 AM

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

lenze · Mar 26th, 2002, 11:29 AM

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

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

davers5 · Mar 26th, 2002, 11:41 AM

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

lenze · Mar 26th, 2002, 11:49 AM

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.

Timehri · Mar 26th, 2002, 12:38 PM

Quote:

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

Tom Schreiner · Mar 26th, 2002, 04:23 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 26th, 2002, 10:02 AM	#1
Timehri New Member Join Date: Mar 2002 Posts: 15	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

Mar 26th, 2002, 11:14 AM	#2
davers5 Board Regular Join Date: Feb 2002 Posts: 255	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

Mar 26th, 2002, 11:29 AM	#3
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	MS Query can do this quite easily. See this excellent tutorial for more info. http://tushar-mehta.com/index.html?h...cel/intro.html

Mar 26th, 2002, 11:41 AM	#4
davers5 Board Regular Join Date: Feb 2002 Posts: 255	What is MS Query? Another program or part of excel?

Mar 26th, 2002, 11:49 AM	#5
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	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.

Mar 26th, 2002, 04:23 PM	#7
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	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