Hello Experts,
I hope someone could help me with this quest:
I have 2 worksheets: sheet-A and sheet-B.
Please what is the vba to:
1. match the part# from sheet-B with part# from sheet-A
2. if a match is found, copy the quantity of the matched part# from sheet-B to the qty field of the same part# in sheet-A.
3. Do loop
Many many thanks in advance. I attach a test workbook for more illustration.
joelle