I'm using a list box so the user can select the player name when entering
team members on a score sheet (sheet 1). The list box range is connected to
the Player Details (sheet 2) and displays all players irrespective of the
team they play for. Using the team name (sheet 1) I want to limit the
players shown in the list box to only those of that team. Sheet 2 contains a
list of the players with a unique player number, their name and the team they
are on.

I'd be grateful to receive suggestions as to whether this is possible and if
it is, how to achieve it.

Thanks,

Dave