Hi,
I am running a charity golf day and wanting to create multiple scorecards which automatically tells you how many strokes received per hole based on the stroke index of the hole and the player's individual handicap.
For an 18 handicap golfer, they receive one shot per hole which will show a black dot next to each the hole, if the player is a 20 handicapper then they receive one shot per hole and one-shot for the two hardest holes.
Probably not explained this very well but I'm looking for a formula to be able to auto-populate these dots based on the handicap figure in another cell. which I think I've done but need to copy the scorecard down the page but return the data from each line in the start sheet
attached is the worksheet
Thanks
I am running a charity golf day and wanting to create multiple scorecards which automatically tells you how many strokes received per hole based on the stroke index of the hole and the player's individual handicap.
For an 18 handicap golfer, they receive one shot per hole which will show a black dot next to each the hole, if the player is a 20 handicapper then they receive one shot per hole and one-shot for the two hardest holes.
Probably not explained this very well but I'm looking for a formula to be able to auto-populate these dots based on the handicap figure in another cell. which I think I've done but need to copy the scorecard down the page but return the data from each line in the start sheet
attached is the worksheet
Thanks