I want to create a spreadsheet that only has a few drop-down boxes or text fields where a person can select their name from the list, enter their data and have it automatically added to the sheet that has their name on it.
We have an Excel workbook that has several spreadsheets with different people's names listed.
Next to their names are columns for people to enter their scores (i.e.- pull-ups).
We are having a contest on who can do the most in a month! :-)
Since we're going to post this on our SharePoint, I want to make it look as easy as possible for everyone.
See the example sheet attached to this post and feel free to provide changes to the existing structure.
It would also be a big bonus if you can show me how to also put a chart of the top 10 scores on the first sheet as well!
Thanks, EE community!