VBA to match data, then copy

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.

Click to expand...

1) which column is "qty" on SheetA ?
2) which column to paste on SheetB ?
3) Is sheet name SheetA of Sheet-A ?

4) have you tried VLookUp function ? (w/o vba)

You need to be clear.

Hello Jindon,

First, thank you so much for looking at my post (thought it had died in cold water).

I did try to illustrate what I want to do but without being able to upload an img, its hard. I will try to re-elaborate the point here:
(also, I dont have the option of doing vlookup! because the qty field in sheetA
has merged cells !!!)


sheetB (customer PO):
Part# Qty
------- ----
xxx205 5
xxx104 11
xxx106 4
xxx118 4


sheetA (before macro is run):
Part# Qty
------- ----
xxx104 [blank]
xxx106 [blank]
xxx101 [blank]


sheetA (after macro is run):
Part# Qty
------- ----
xxx104 11
xxx106 4
xxx101 [still blank, no match from sheetB]

As you can see, if macro can match up the part# from sheetB with the part# in sheetA, only then, macro will copy the [qty from B] to the [qty in A] with respect to the matching part#. Here, we have 2 instances, the qty of xxx104 and xxx106 from sheetB is copied to the qty of xxx104 and xxx106 in sheetA. Pls note direction: sheetB ---> sheetA.

It would just be wonderful to know if vba can do this magic!
I'm still holding hope !!! btw, would someone tell me how to attach a .gif img??? thanks.

joelle

Cross-posted: http://www.vbaexpress.com/forum/showthread.php?t=16023

Firefytr,

Sorry, I should have mentioned that I crossposted.
Yes, normally I did not do crosspost. But I'm under time pressure and I do not have much luck on the other forum. I just would like to get more inputs to solving the problem.

(also, I dont have the option of doing vlookup! because the qty field in sheetA
has merged cells !!!)

Click to expand...

Hummm...
Too hard to imagine without seeing your sheet.
Why merged, anyway ?