Excel newbie needs an if statement (maybe???) to copy/paste rows of info to new sheet

[Saiklor]

So I'm a complete noob and not a programmer. Apologies in advance.

Example Spreadsheet 1.xlsx

I'm working on a database of volunteers. I've attached an example. The database is the same but I made up fake names as you'll see.

I need this to automatically copy/paste the records from the main page to the other pages based on people's checked off interests.

So as you see, Jane Doe would really like to help with Bingo. On the Bingo tab/sheet/thingy (SORRY!) I'd like her information to appear, exactly as it does there (column of volunteer number, column of last name, column of first name, column of email, and column of phone number). I need these so we can print out lists and do automated emails from these lists (which is a whole other kettle of fish I'll figure out later!)

I am able to put in checkboxes (as you can see, I added one there by Jane Doe to prove I can figure THAT out), so I am willing to change the spreadsheet from X's to checkboxes if neccesary.

Please help! And babystep instructions if you have the patience for it.

Thank you very much.

[djapigo]

Hi Saiklor,

I suggest you look into filters... this way, you don't have to separate out each group... for example, if there are a bunch of Bingo volunteers, then you simply "filter" all the x's to get your list of volunteers...

Let me know if you still don't understand...