Compairing columns from two workbooks and updating data in

[eddy]

I need to write a macro which will look at two workbooks ( A & B), then
update the price column (say column J)
contained in a worksheet within workbook A with the data contained in a
worksheet (column J) within workbook B.
Both A and B workbooks have a common P/No field but the similar P/No's will
almost certainly be on different lines
numbers. I am sure VLOOKUP will come into the equation somewhere.
Thanks for the help.
eD

_________________
From eD
traspberries@hotmail.com

[ This Message was edited by: eddy on 2002-03-05 13:32 ]

[Aladin Akyurek]

On 2002-03-05 13:30, eddy wrote:
I need to write a macro which will look at two workbooks ( A & B), then
update the price column (say column J)
contained in a worksheet within workbook A with the data contained in a
worksheet (column J) within workbook B.
Both A and B workbooks have a common P/No field but the similar P/No's will
almost certainly be on different lines
numbers. I am sure VLOOKUP will come into the equation somewhere.
Thanks for the help.
eD

_________________
From eD
traspberries@hotmail.com

[ This Message was edited by: eddy on 2002-03-05 13:32 ]

Not sure why you want a macro here, but you can use in column J in the WB that needs prices from the WB that has that information.

Your description of the problem omits alas much of the lay-out of the relevant data in both workbooks, so it's hard to be specific.

Aladin