Ok I am doing a workbook for my track athletes. Each one has their own worksheet in the workbook. In every I10 cell there is a value that is their average score. I want to Index the scores (so I can rank them) on a master sheet. How can I do this without typing going back and forth copying the destination of the cell into the index.
I've attached a copy of the workbook. The names of the worksheets are each athlete. The index sheet is where I want everything to go. I started to manually put the first three in there just to show an idea of what I want it to look like. Thank you!
Bookmarks