Managing sports into seperate list and a master

[starberst]

I am trying to create a spreadsheet that will contain the list of all athletes at our school. Other sheets (Tabs at the bottom) are to have each sport and those athletes that participate in that sport. As I add a new student (athlete) to the master list, I want them to add or delete from the individuals sports sheets. I was thinking I could create the individual sports first then populate a master list. I am stuck. Is there a video on line you would recommend I watch? Thanks

 

[Andrew Poulsom]

Welcome to MrExcel.

Why don't you have one sheet with a list of athletes in one column and their sport(s) in another column? Duplicate the athletes if they have more than one sport. That way you will be able to use Excel's built-in data analysis tools like AutoFilter and Pivot Tables.

 

[starberst]

This list has a lot of other information attached to each row like GPA, last, first, grade, student ID, gender and sport. when I fill in the sport cell, I want it to populate that particular sports spreadsheet with all of the students information just like the master. there are 26 sports and about 500 athletes. This way each coach can have a list of their athletes on their own spreadsheet. Not sure if this is possible.

 

[Andrew Poulsom]

Maybe this will help you:

http://www.mrexcel.com/forum/excel-questions/49839-transfer-data-another-worksheet-name.html