mercredi 1 juillet 2015

Macro to Randomly Assign Names to Groups without Repeating

I am looking for a macro that will randomly assign names into a group. There are 16 groups and they each need 10 names randomly assigning to them. The list of names is on a different sheet and ideally I would just like to run a macro which will paste 10 random names from the list into each group without any repeats. Is this possible? I haven't had any luck finding a solution anywhere else.

Thank you.




Aucun commentaire:

Enregistrer un commentaire