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!