software

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!

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:
www.contextures.com/xlFunctions02.html

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

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

--

Dave Peterson