I have two workbooks. One (which I've uploaded) named "Master" and another named "Update". They are the same in regards to structure and format. Only some of the data is different. In both workbooks, Column A contains model numbers. Columns K & L contain corresponding prices for those model numbers. The same exists for column N (model numbers) and Columns X & Y (prices). In both workbooks all prices are either (font color) black, red or blue.
My task is to compare the two workbooks looking for model numbers in the "update" workbook which are also found in "Master". (columns A & N in both workbooks) When a duplicate model number is detected, using the "Master" model number, check the price in column K. If it is black, do nothing. If it is red or blue, copy it and paste it on the "update" workbook in column K in the row of the corresponding model number. Then, do the same for the price in column L.
The same process would be applied to the model numbers in column N and the corresponding prices in columns X & Y.
So, the end result would be...
From the Master workbook any prices which are Red or Blue would be inserted into the correct location in the Update workbook. Any Black prices in the Master workbook are left alone.
Solved by C. D. in 15 mins