Hello,
i need an alert that triggers if the the following criteria is met:
IF the value in Cell A1 is not found in a list (e.g. Cells C1:C15) and Cell B1 = 'Mover' or 'Leaver' Then Alert ("The user is not currently on the List of Active Users. Please ensure the name is correct, and that it is spelt correctly')
I have only used Macros that trigger from buttons, so am unsure how to go about this.
Thanks,
Bookmarks