match data, then copy

Hello Rylo,

So glad to see your msg!
Yes, I do need vba because the sheetB with the destination qty col is actually a big sheet with 1200 lines.
sheetA, however, has about 50 lines for the products that customer orders.
Then, what I try to do is, if the part# match, the qty should be copied to the qty field of sheetB on the row that has that particular part#. A brief illustration below:

sheetA
part# qty
xxx102 2

sheetB (before macro)
part# qty
xxx102 (blank)

sheetB (after macro, part# xxx102 matches)
part# qty
xxx102 2

I really really do hope you/others can help me with this vba code.

N.