Hello everyone,
I would greatly appreciate if someone can help to create a VBA code to randomly select 10 employees from a list of employees. Every time the VBA code is executed, it should select no duplicates or repeats and then copy and paste into two worksheets with the appropriate random selection. The random selection should be based on the following criteria:
1. Employee status should be active (not on leave or suspended)
2. Scope should be included
Finally the generated worksheets (RandomList1 and RandomList2) should be broken down by shift and language. For example, RandomList1 worksheet should include 10 active employees from A shift with included scope and only 1 language. RandomList2 worksheet should include 10 active employees from B shift with included scope and only 1 language.
I have attached a sample file to demonstrate a final result.
Again, thank you for your valuable time and dedication to this wonderful forum.
Bookmarks