I have a table as below in Excel sheet 1
Column1 column5
Item Name Qty
ABC179 32000
XYZ245 308500
ABC260 355

I have a table as below in Excel sheet 2
column3 Column8
Item Name Qty
ABC179-adff formula??
ABC260-ssvs formula??
XYZ245 - dbvbffbvbdb formula??

I have detailed name list of the Item in the above format (6 digit code matching Excel sheet 1 and then followed by description) in Sheet 2 and I want the qty details in Sheet 1 to be copied to Sheet 2.FYI: Order also might be changed..

I would be of great help if any one could give me a solution. thanks in advance..