I have 2 sheets.
One 'Content' has Product Code in A11-A2912 and Price E11-E2912, and some fields are blank.
The new data is in a separate sheet 'New Price Data' with Product Code in A1-A1409 and Price in B1-B1409. The Product Codes in 'New Price Data' are in numerical order but they aren't in 'Content'.
I need to compare Product Codes and update Price data in 'Content" with data from "New Price Data'
I hope this is clear enough
I know this would of already been answered somewhere but I couldn't find anything I could translate to my problem.