A Non-VBA Solution....
Insert a helper column just to the left of the current price, this helper
column will be deleted later.
Assuming the following: SKU (part number) is in column A, unit price is in
column D, your helper column is column C. And assuming your 'price updates'
have SKU in column A, and new price in column C.

Type the following formula in helper column (C) in wkbk A.
=IF(COUNTIF([wkB.xls]Sheet1!$A$2:$A$100,$A2)=1,VLOOKUP($A2,[wkB.xls]Sheet1!$A$2:$N$5,2,FALSE),"")
This will populate column C with ONLY the new prices, leaving prices that
remain the same as blank.
Highlight the entire data selection, Data--Filter--AutoFilter. Filter for
NonBlanks on the newprice column, this should leave only the data for cells
that have new prices.
Highlight columns C and D and use Edit--Fill--Right.
This will move the formulas moving over dragging along the new price. NOTE:
Ensure you are filtered, as you don't want to erase the old prices.
Then show all (Data--Filter--Show All).
Highlight the entire column of prices (column D), copy, paste special in its
own column (still column D). Then delete column C.

I am sure there are VBA methods too.


--
John C


"Hummingbird" wrote:

I have a worksheet that has many columns. One of the columns contains Vendor
Sku Numbers and another column on the same worksheet contains Price
information for that Part Number. I need to update pricing information
regularly based on a new worksheet that I receive which has the part numbers
and new pricing. How do I update pricing for thousands of parts without
having to look at each row and column.

example:
wks "A":

Vendor SKUNumber Descr Price
0120 Bulb 1.35
0115 Pen 2.68

wks "B":
Vendor SKUNumber Descr Price
0120 Bulb 1.44
0115 Pen 2.78