Hi guys!
New member here and I am pulling my hair out trying to create an excel sheet for groups. I have to create random groups for different events. So I have a main list of all the people, and then to randomly create groups, I used a website that randomly scrambles a sequence of numbers. Now I need an easy way to copy rows from the main list to the individual group sheet. To make it easier to understand what I am trying to do, I attached a sample excel file that is setup like the real one but with different data entered of course. Also, my main lists of people aren't always 100 people. It can be more or less, even and odd amounts. There will always be 5 groups though.
On the group 1 sheet I copied the first row over to show what I'm trying to do.
Thanks in advance for any help!![]()
Bookmarks