Random Name Finding

An Excel file that teaches how to perform Creating Personnel Records with UserForm operation.

Excel Solution: Random Name Finding

The name list is defined as a table. An index is generated using RANDOM. The INDEX function returns a value. A check is added based on the repetition preference. Selected records are marked. A re-draw is triggered with a button.

Hope it is useful.