Hello,
I have raw data in two different excel workbooks: 1 & 2. I'm trying to create a formula/macro that would search a column in each work book for identical values. The workbooks are broken down into three columns A B & C. If the cell value in column A-work book 1 is the same as any value in column a-workbook 2, then its adjacent value in column B is copied over from workbook 2 to workbook 1.
Please help me out with this, and if I didn't make it clear enough please let me know. Thank you.l