Dear Gurus:

Please take a look of the following tasks and see if you can make a code to automatize the process.

Pseudo Code:

*This code should update the sheet Quote Summary from Sales Summary Only

1, Start from Row 2 on Quote Summary Sheet,
If F2=0 or blank, then try to find the value of A2 in Quote Summary from column A in Sales Summary
If a match is found in cell Ai in Sales Summary sheet, then update F2 in Quote Summary with the value in Di in Sales Summary sheet.
If no match is found, just leave it and start next cycle.

2, Repeat for all of the rows in the sheet Quote Summary

Process Sample 5-Update Sheet A from Sheet B.xlsm

Thank you,

Chris