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!