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
golfouting_commishAsked:
Who is Participating?
 
bromy2004Connect With a Mentor Commented:
do you want the names in the "leaderboard" sheet to be retrieved and ranks?
Will there be more sheets for the other games?
or will the be other values in the "LeaderBoard" Sheet?
0
 
golfouting_commishAuthor Commented:
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.
0
 
bromy2004Commented:
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)
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
golfouting_commishAuthor Commented:
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
0
 
bromy2004Commented:
so you still want help?
the question is now closed?
0
 
golfouting_commishAuthor Commented:
all set  thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.