Hello,
i've been tasked with creating a macro to determine if a name is present in a list, and if it is present - randomly select a value(case) corresponding to that person from another column. So for example, in the sample data i pasted below, how to find if Will is present, then randomly select one of his cases? any assistance would be much appreciated
Cases EmpIDs
CA70914 Will
CA11254 Will
CA75853 Jill
CA69664 Jim
CA87459 Jim
CA72493 Jess
CA73302 Mike
CA74037 Bill
CA74791 Will
CA78075 Grant
CA74436 Karen
CA75873 Alice
CA75266 Nora
Bookmarks