Convert 2 workbooks into 1 workbook
 

I have 2 workbooks.
Workbook 1 has about 3600 rows of information. There is 5 column headings:
part number, description, code, Yes/No option, and Country
This is a list of parts for a certain customer last year.
Workbook 2 has about 3700 rows, but heading are the same. This is a list of
parts imported today. It has the same kind of info except newer (updated)
info.
The only manual change done on WB 1 was the Yes/No column. Yes basically
means we make it here in the US.
The fresh import all says No. It's a manual entry, not imported.
WB 1 and 2 have duplicates. The reason I want the old to overwrite the new
when the part number is the same is to get all those Yes/No back. Otherwise I
have to go through 3700 parts again.
Any help would be great! Thanks!

Convert 2 workbooks into 1 workbook
 

Maybe you could just bring the yes/no into another column.

If each part number shows up once in each file, you may be able to use
=vlookup().

You may want to read Debra Dalgleish's notes:
http://www.contextures.com/xlFunctions02.html

Then you could see which yes/no column should be kept.

jeridbohmann wrote:

I have 2 workbooks.
Workbook 1 has about 3600 rows of information. There is 5 column headings:
part number, description, code, Yes/No option, and Country
This is a list of parts for a certain customer last year.
Workbook 2 has about 3700 rows, but heading are the same. This is a list of
parts imported today. It has the same kind of info except newer (updated)
info.
The only manual change done on WB 1 was the Yes/No column. Yes basically
means we make it here in the US.
The fresh import all says No. It's a manual entry, not imported.
WB 1 and 2 have duplicates. The reason I want the old to overwrite the new
when the part number is the same is to get all those Yes/No back. Otherwise I
have to go through 3700 parts again.
Any help would be great! Thanks!

--

Dave Peterson