Easily copying rows from one sheet to another

[Anteater]

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!

[FDibbins]

Hi Anteater and welcome to the forum

i think you forgot to attach the file?

[Anteater]

Ooops! Attached now

Thanks for the welcome!

Hi Anteater and welcome to the forum

i think you forgot to attach the file?

[FDibbins]

so the numbers on grp1 sheet - 9,53,56,90 etc come directly from sheet2? and then you want to find the random number from grp1 sheet in the list of random numbers from full list?

it seems that you will have a random change of finding a constantly changing random number in a constantly random list.

the mechanics of doing the search are very simple, you use =vlookup(), but to find the ID is going to be a problem (I recalc'd dozens of times to try and get a number match, with no "luck"). so i would suggest you rethink how the ID numbers are generated?

[Anteater]

so the numbers on grp1 sheet - 9,53,56,90 etc come directly from sheet2? and then you want to find the random number from grp1 sheet in the list of random numbers from full list?

it seems that you will have a random change of finding a constantly changing random number in a constantly random list.

the mechanics of doing the search are very simple, you use =vlookup(), but to find the ID is going to be a problem (I recalc'd dozens of times to try and get a number match, with no "luck"). so i would suggest you rethink how the ID numbers are generated?

Ah I'm sorry, the ID numbers aren't random on the actual sheets. I just did that to have a number there. I revised my worksheet to hopefully make my goal clearer. I added a new column A that has the random numbers that are used to generate the groups. So if the row on sheet 3 could search for the corresponding row on sheet 1 and then use that information from that entire row, that would be perfect. Hopefully that makes it a little clearer. I'll admit I'm a bit confused myself trying to explain it.

[FDibbins]

there still is a mis=match between the ID numbers on sheet1 to the other sheets. however, try this in you're real file and see if it gives you what you want?

=IFERROR(INDEX('full list'!$A$1:$F$101,MATCH('group 1'!$B2,'full list'!$B$1:$B$101,0),MATCH('group 1'!B$1,'full list'!$A$1:$F$1,0)),"")