Random List Generator How to copy Columns A and B to Sheet 2

Here is one solution possibility:

On sheet2, in column B, type =randbetween(3, 11236)
On sheet2, in column C, type =VLOOKUP(B1,Sheet1!$A$2:$B$860,2,FALSE)

copy them down as many rows as you need to get tests for. A note of importance, your list of employees has fewer numbers than the difference between 3 and 11236. These were the Min and Max of your list. These numbers (missing) will generate #NA. You may have to expand your output to get the number of random selections you are looking for.

This might suit you.
The random selection routines that I added return N randomly selected employees. Those employees are not checked against the "already tested" list in Sheet2.
I've added the feature that the date (of test?) is added to Sheet2 for record keeping.

If you want to test the selected against the list of in sheet2, I would use a different approach.
Randomize the whole employee list, write that in Sheet2 without dates.
When you want to test 3 (or 5) employees, test the first 3 (or 5) from the list in Sheet2 that don't have a date next to their names. Add the date of testing to those employees.

Note the DefaultWriteRange function in the UF code module and the EmployeeList function in Module 3.
If you change your workbook layout, these should be adjusted, but those are the only places that these hard coded values need to be changed.

All you have to do is control the Size argument that is passed to ChooseNWorkers
If you want to choose 32% of your workers

Please Login or Register  to view this content.

I just noticed that you probably want to change the default DestinationRange inside ChooseNWorkers.

The first argument of ChooseNWorkers is the number of workers to be chosen from the EmployeeList.

To select N percent, just set that first argument to N%*number of workers (which is EmployeeList.Rows.Count)

Change this line

Please Login or Register  to view this content.

Did I spell that right, or is the function's name EmployeesList?