match data, then copy

Hello Experts,

I hope this is quite simple for you vba experts but I'm a very beginner so please help!

I have 2 worksheets: sheet-A and sheet-B.
Please how do I:

1. match the part# from sheetA (col B) with part# from sheetB (col A), then
2. if a matching part# is found, copy the qty of the matched part# from sheetA to the qty field of the matching part# in sheet-A.
3. Do loop

I attach an img for more illustration of the above.

Many many thanks in advance.
N.

Hi

Do you have a particular requirement that it must be a macro when you could achieve the result using Functions?


rylo

You can achieve that result without VB code.
Spreadsheet functions are much faster than VB code and are prefered unless there is an overiding reason not to.

In your case, putting =SUMIF(SheetA!B:B,A2,SheetA!A:A) in SheetB C2 and using fill down to fill the rest of column C will get the result you desire.

Mike,

Pls look at the img I attached earlier. I do really need vba:

1. You're right - I have an overiding reason not to be able to use the formula sumif

2. the destination "qty" col in sheetA consists of merged cell, while the qty col from sheetB has single cell for each qty.

thats why I need vba code badly for this case. I can see now it is a challenge and very interested in knowing if vba can do something for this.

Many thanks to you and others for any hint in helping me with this roadblock.

N.

Hi

Not really obvious from the image that there are merged cells involved.

Can you zip up an example workbook showing both sheets and explaining what should go where so we can review.


rylo