If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
linking 2 work sheet to update one sheet
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 |
#2
|
|||
|
|||
linking 2 work sheet to update one sheet
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 |
Thread Tools | |
Display Modes | |
|
|