Hi
you may have a look at VLOOKUP for updating existing parts in your old
worksheet:
e.g.
=VLOOKUP(A1,'new_sheet'!$A$1:$B$1000,2,0)
where col. a stores the part number and column B the price

for adding missing items to your list you may have a look at
http://www.cpearson.com/excel/duplic...#InOneNotOther


--
Regards
Frank Kabel
Frankfurt, Germany


andy wrote:
hi all i am trying to update a price list with part
numbers i have 2 list with part no and prices but i need
to be able to update the old one from the new one with
upto date prices i.e if part number x224 on sheet one is
the same as x224 on sheet two then update price for that
part no x224 from sheet 1 to sheet 2 if part no is new on
sheet 1 then add part no and price to sheet 2 thank for
the help if any one can