Hi,

Firstly I dont know if this is possible but if it is please let me know how to do it.

Table A contains a column of part numbers and a column of descriptions.
Table B contains the same part numbers but the descriptions have been corrupted.

Therefore I want Table B to look at Table A and for a given part number, copy its description and paste over the same part numbers description in Table B.

So does anyone know of an automated way to accomplish this?

Thanks in advance.
Rod.