I have a list of approx. 3000 titles that will need to be changed. I have this in "Master_List.xls" where Column A and Column B, when used together, are unique. Column C shows the new title. Column D shows the new code.
I will have approx. 12-15 spreadsheets that will need to be compared against this list. Again, The data type will mimic Columns A|B|C|D, so the columns match in type.
Is there a way to run a macro or programming that, once I have both workbooks open, it compares Column A and B of the new workbook and compares them against Column A and B of the "Master_list.xls" workbook. If the code is found in the master list, then Copy Columns C and D and replace them into the other workbook in Column E and F ? I would prefer to not overwrite C and D since I want to visually check.
Thank you.
Gene
Bookmarks