Sorry, msa969, weak efforts on my part. I'll build a VBA solution. Check back in an hour. - Lee
Make that 22:00.
Ok, sorry for the delay, had to stop by the office. Here's a macro that handles the randomizing and group distribution. It allows for changes in the student list (which is sorted each time it's run) AND the number of groups. I also re-arranged your sheet, hope that's acceptable. Regards-Lee
RNDgrp.png
And the code:
Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee
Bookmarks