Seamus2626
asked on
Update mapping table using VBA
Hi,
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!
Seamus
Mapping.xlsx
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!
Seamus
Mapping.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.