I have 2 spreadsheets that have the colums : Partnumber, description, price.
One is the current version, and the other has updated prices. Actually, the
one with the current data has 2 additional columns, but the first 3 columns
are the same in both.

Here's what I need to do :

Assume A=current, B=new

Compare A to B, updating 'only' the pricing cell in A where there are
identical part numbers.

I also need to know what parts from B are not in A, so that they may be added.

Does anyone know how to do this? I don't care if it's an add-on product -
I'm desparate!

Thanks