I have a set of source codes in Column A and a set of what should be matching codes in Column B, however there are some codes missing in Column B. I'm trying to find a way to quickly identify the missing codes in Column B, either by either having a macro that somehow moves the entries in Column B so they match those in Column A, giving the result shown in Columns E and F (in the attached, I've only shown the first 30 rows).
Alternatively, a method that highlights which entries in Column A are missing in Column B could work, using Conditional Formatting or another, posibly better idea is to extract the entries in Column A that don't appear in Column B and copies these entries into another column (without any gaps).
I'm not really sure where to start to achieve this?
Many thanks
Bookmarks