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
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Martin Liss
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Visual Basic Classic
Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.
165K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
