Hi,
I'm having trouble finding a solution to this...any help would be greatly appreciated.
I've created an indoor cricket scoring spreadsheet for our local competition.
It has two sheets - one with team names across the columns, with names of the players under each team name.
In the other sheet I have the game scoring info.
There's a drop down list to select the first batting team, and a second drop down list to select the fielding team.
What I'd like to do , which I'm having difficulty with is, to display the players names down the column.
eg selecting the batting team, and the names of all the players appear down the column under batting team and the names of the players in the fielding team down another column
under fielding/bowlers.
The players names will change depending on which team is selected from the drop down list.
There's probably a simply solution, but haven't been able to find it!
many thanks
cheers
vin
Have attached an earlier version of the spreadsheet.... the current version is saved on another laptop currently at home.
The yellow area, is where the players names should appear based on the team selected at the top of the page, under fielding team.
Bookmarks