I’m a captain of a bowls team and I’m trying to produce amaster score sheet in Excel 2007.
What I have is an individual game sheet that is manuallypopulated with players and scores. I want the scores to be transferredautomatically to a master score sheet containing all games against theappropriate team members.
For instance the game sheet which is manually completed willhave 4 columns say A, B, C, D and 10 rows for the number of players in a game.
For home games
Column A will have my team player name
Column B will have their score
Column C will have the opponent’s name (which is notimportant)
Column D will have the opponents score
For away games
Column A will have the opponent’s name (which is notimportant)
Column B will have the opponents score
Column C will have my team player name
Column D will have their score
Rows 1-10 will have the players names.
For the master score sheet
Column A will have manually inserted team members name
Column B will have either my team members score if at homeor the opponents score if away for game 1.
Column C will have either my team members score if away orthe opponents score if at home for game 1.
Columns D & E, F & G etc will continue in the sameformat for games 2, 3 etc.View attachment test Result Sheet.xlsx
What I have is an individual game sheet that is manuallypopulated with players and scores. I want the scores to be transferredautomatically to a master score sheet containing all games against theappropriate team members.
For instance the game sheet which is manually completed willhave 4 columns say A, B, C, D and 10 rows for the number of players in a game.
For home games
Column A will have my team player name
Column B will have their score
Column C will have the opponent’s name (which is notimportant)
Column D will have the opponents score
For away games
Column A will have the opponent’s name (which is notimportant)
Column B will have the opponents score
Column C will have my team player name
Column D will have their score
Rows 1-10 will have the players names.
For the master score sheet
Column A will have manually inserted team members name
Column B will have either my team members score if at homeor the opponents score if away for game 1.
Column C will have either my team members score if away orthe opponents score if at home for game 1.
Columns D & E, F & G etc will continue in the sameformat for games 2, 3 etc.View attachment test Result Sheet.xlsx
