match two column in sheet 1 v shee 2 and find the result column

You can use SUMPRODUCT. Assuming that Partno is on Col A and Job and Qty on Col B and C resp. Type the following on D2 of Sheet1:

Please Login or Register  to view this content.

smlim7,

I assume that your title Partno on both worksheets is in cell A1.

The macro uses columns D in both worksheets as a helper column.

Detach/open workbook UpdateW1 if Partno_JOB found with w2 Qty - smlim7 - EF781452 - SDG12.xls and run the UpdateW1 macro.



If you want to use the macro on another workbook:


Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).


1. Copy the below code, by highlighting the code and pressing the keys CTRL + C
2. Open your workbook
3. Press the keys ALT + F11 to open the Visual Basic Editor
4. Press the keys ALT + I to activate the Insert menu
5. Press M to insert a Standard Module
6. Where the cursor is flashing, paste the code by pressing the keys CTRL + V
7. Press the keys ALT + Q to exit the Editor, and return to Excel
8. To run the macro from Excel, open the workbook, and press ALT + F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.

Please Login or Register  to view this content.

Then run the UpdateW1 macro.