asked on

golf outing spreadsheet

I have attached a file that we use for our golf outing. It is my desire to have this spreadsheet label the winners and assign points according to the manual input of gross scores.

In the attachment I will manually input data into the sheet "Scores" I would like to have the sheet arrange the names in order of points won for each round and also put into the tab "Leaderboard" 0000001111122222.xlsx

ASKER CERTIFIED SOLUTION

bromy2004

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

golfouting_commish

ASKER

primarily what the POINTS to be automatically calculated into the "scores" sheet after the manual input of the golfers actual score. The POINTS awarded are spelled out in the tab "scores" I can figure out how to have the players score to be filled into the "leaderboard" tab but at the present time after I input the players score into the "scores" tab I must then highlight and sort the field to arrange in a stacking order then assign the corresponding POINTS awarded then transfer to the leaderboard. Trying to figure out if it is possible to have it done automatically once the scores are manually input.

bromy2004

So you want Column K in "Leaderboards" to update automatically from "Scores" and the names to sort automatically by Column L in Scores (Final Points Totals)

golfouting_commish

ASKER

see new attachment. i want column y in the scores sheet to be fillled in with the values found in AA21:AE:32 automatically after i manualy input the players score from their play.
0000001111122222.xlsx

bromy2004

so you still want help?
the question is now closed?

golfouting_commish

ASKER

all set thanks