Excel Macro to Identify Duplicates and Move Data
Posted on 2014-02-18
I'm trying to achieve the following in excel.
I have four columns. Columns A, B, C, D.
Columns A, C, and D have data. B is empty.
I want to accomplish two things. I want to identify and highlight matching values in columns A and C. When there is an match, I want the data that's in Column D, that is in the same row as the cell that was matched in column C, and I want that value copied and pasted into Column B (empty columns) in the row as the corresponding/matching value in Column A.
I hope is clear. Is this possible to do with a macro or with any addons?