Advanced Find and Replace VBA Help

[Remotruker]

Hello All- be gentile please!

I have a find and replace situation that I’m attempting to resolve but have been unsuccessful.

Sheet “Last Week” Contains last week’s data
Sheet “This Week” contains some updated information that I want to replace, but only if there is updated information.
Sheet “Update” to contain the “This Week” updated data, but I need to preserve the comments related to the specific widget(product number)

Workbook attached

[davesexcel]

I am not sure if I see a question.
What is the question?

[Remotruker]

Hello All- be gentile please!

I have a find and replace situation that I’m attempting to resolve but have been unsuccessful.

Sheet “Last Week” Contains last week’s data
Sheet “This Week” contains some updated information that I want to replace, but only if there is updated information.
Sheet “Update” to contain the “This Week” updated data, but I need to preserve the comments related to the specific widget(product number)

Workbook attached

My question if not clear (Sorry) is how do i write a VBA to make "Update" contain the new data from "This Week" and preserve teh comments related to the specific widget? Also if anything is added or drops off the list some notification would be helpfull there too. I'm thinking a Strikethru if something drops off and a color change if a new widget appears.

[Remotruker]

Ok maybe i can Start Over and simplify this:

Given:
I have a "Data" Sheet with Raw Data
Column A has item number, Column B has Qty
I Have a "Result" Sheet with cells i want to update
Column R has same item number, Column S has Qty(that needs to be updated)

Here is what I want to accomplish with VBA:

Select Sheet "Data"
X= Cell A1, Y= Cell B1
Select Sheet "Result"
Find X
Replace the next cell to the right with Y
Find Next Occurrence and replace again (if it exists), If not:
Select Sheet "Data"
X = Cell A2, Y=B2

(repeat the find and replace routine)
If Sheet "Data" Next item in the list (ex A1000) does not contain data, quit.