Match and replace cells between two worksheets
 

I have two worksheets, each with three columns. First cell is a part
number, the second cell is a vendor abbreviation and the third cell is
a vendor ID number (EX: cellA = abc123, cellB = HONE, cellC = 749) This
is the same format on both worksheets. When a vendor ID number changes
on one worksheet I want to be able to change it automatically on the
other. Worksheet 1 may have several hundered or more entries and
several entries the same under cells b and c because there are many
part numbers from the same vendor. On worksheet 2, there may not always
be a match with worksheet 1. All i want to do is change the vendor
number, so if i change the HONE vendor ID from 749 to 800 on worksheet
1, i want to be able to run something that will find all of the HONE in
columnB on worksheet 2 and change then value in column C to 800. The
part number does not play a part in this of than to give a reason for
having multiple occurences of the vendor name in a column.


--
researcy
------------------------------------------------------------------------
researcy's Profile: http://www.excelforum.com/member.php...o&userid=31948
View this thread: http://www.excelforum.com/showthread...hreadid=516699