I have a process where i get updated mapping tables using a key in Column U - its very manual - vlookups etc
I would like some code that checks
(1) if the keys are the same
(2) if they are, are W,X or Z different
(3) if they are different - put whatever name is in new mapping into Mastersheet
In this instance, after code was ran - MasterSheet would be W (Batman) - X (Bob Builder) & Z (Denis Menace).
Any other sugegstions / processes would be appreciated - thanks!