update cells from 1 sheet to another

[fieldingyo]

How can i create a macro or something that finds value A on spread sheet 1 then takes the value located the cell next to it, call it value B and then finds value A on a spread sheet 2 and pastes value B in the cell next to it?

I hope that makes sense. I need to update prices from one spread sheet to another by using a unique product ID that is in both sheets.

Thanks in advance!!

[JBeaucaire]

I would use a formula on spreadsheet 2 in column C to do the search.

In Sheet2!C2:

=IF(ISNUMBER(MATCH(A1, Sheet1!A:A, 0)), INDEX(Sheet1!B:B, MATCH(A1, Sheet1!A:A, 0)), B1)

Then copy that cell down column C. All the NEW prices will appear or the old price from the current page if the item is not found on Sheet1.

Then, copy the new price column C, then EDIT>PasteSpecial>Values into column B...clear column C and you're done.

You could write all that into a pretty quick macro, just using the macro recorder...