Update Sheet A from Sheet B When a Match is Found

[aviatecar]

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

[PCI]

It means there is no duplicate in Column "A" in sheet "Sales Summary"

[aviatecar]

Hi PCI:

Not sure what is the context of this reply but no duplicates is supposed to be in column A in sheet sales summary.

Thanks,

Chris

[PCI]

See next code

Please Login or Register  to view this content.

[PCI]

Take care I made a change in the code

Please Login or Register  to view this content.

But it's not enough because cells are not empty there is a space.
What do you want to do:
Remove the space to have real empty cells in your data
or change the code by

Please Login or Register  to view this content.

[PCI]

let's do all case
See attached

[aviatecar]

Thanks for pointing it out!

What about take all three condition into consideration?

Like this:

Please Login or Register  to view this content.

[PCI]

Yes of course, see the previous file attached

[aviatecar]

Great Code!

Thanks you PCI.

Btw, please take a look of this thread:

http://www.excelforum.com/excel-prog...ml#post3889310

Its should be an extremely simply code for your but please make sure it only applies the sheet "Quote Summary"

Thank you,

Chris