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