Excel macro to pick names at random from a list. This video tutorial looks at using Excel VBA to generate a list of random and unique names from another list.

A user specifies the number of names they want picked at random from a list. The macro then returns the multiple names to the spreadsheet. All names are unique and not returned more than once.

The tutorial demonstrates many useful VBA skills such as array variables, Do and For loops and an If statement.

The VBA code can be found at the link below. This code can be copied and adapted to your needs.
[ Ссылка ]

If you want to learn Excel VBA, take this online training course
[ Ссылка ]

Find more great free tutorials at;
[ Ссылка ]

*** Online Excel Courses ***

The Ultimate Excel Course – Learn Everything ► [ Ссылка ]
Excel VBA for Beginners ► [ Ссылка ]
Advanced Excel Tricks ► [ Ссылка ]
Excel Formulas Made Easy ► [ Ссылка ]
Creating Sports League Tables and Tournaments in Excel ► [ Ссылка ]

Connect with us!
LinkedIn ► [ Ссылка ]
Instagram ► [ Ссылка ]
Twitter ► [ Ссылка ]

свернуть