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
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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?

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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.
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)
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

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.
so you still want help?
the question is now closed?
golfouting_commishAuthor Commented:
all set  thanks
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.