Hi. I need to create a spreadsheet to show the results of golf competitions for next season.
the first page will have all the relevent golfers names on it & across from that the venues.
I want to be able to put the golfers score into the box adjacent to their name & venue.
I then need it to fill in on another page a league table (leaderboard) this needs to adjust the golfers position.
I will also have a seperate spreadsheet, linked which will also show the individual event venue & the positions finished at that venue including points.
so when information is inputted into sheet one with golfers & venues, it automatically fills in the individual event sheet & also fills in & updates the yearly leaderboard.
I have attached a spreadsheet example from last season, however the score will now have to be put in manually on the golfers sheet, & I do not know how to do this?
I believe there is hidden formulae etc?
Please Note these are made up names!!
I would appreciate anyone's help. I am frankly totally useless with excel.
Thank you!
Moderator's Note: As per Forum Rule #1, please use a more descriptive title next time when posting a question…Thanks.
Bookmarks