Creating separate lists from a master list based on conditions

I am coordinating a lacrosse tournament and have a long list of players that need to be assigned to a different games and want to have a list of players assigned to each game generated automatically.

It is sort of like the "autofilter" concept except insted of hiding players in the master list on a condition, instead I want them to be added to a separate list.


The data is a master list with player names in one column, then a column for each of the 6 games. I enter a 1 in each column that a player is assigned. I total at the bottom to show how many players are assigned to each game and total on the right to see how many games each player is assigned to. We shift players around to try to cover all positions and ensure we have a balanced team so havnig the roster list update automatically makes this much easier.

Note - I am not much of excel programmer but can often figure things out with some direction.

Thansk to anyone for suggestions!

Hi kenk99

Welcome to the Forum

You would do best to post a sample workbook showing Before and After.

It should clearly illustrate your problem and not contain any sensitive data.

Cheers

Thanks for the suggestion.

Here is my sheet - obviously there are a much larger number of players. I don't have any programming in there now, but essentially you can see the rosters at the bottom that I want to automatically populate based on the data in the top of the matrix. I manually populated one roster as you can see

We need to do "trial and error" and move people around to balance things so easily seeing the assigned rosters would be very helpful. We also get lots of last minute changes from parents so want to be able change the "1" to a "No" and have the rosters and counts get updated - that will help reduce errors.