Easiest Way to Sort and Find/Display

Closed
Frank - Aug 18, 2010 at 09:58 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 20, 2010 at 08:35 AM
Hello

I'm looking for the easiest way to manage, sort, find, and display about 300 cross country runners statistics. In column A, I have dates; in row 2, columns B through H I have resting heart rate, warm up, workout, cool down, # of aerobic mins, # of anaerobic mins, and # of flexibility mins.

Would I need to create a worksheet for each student? Come parent-teacher conference time, what would be the easiest/quickest way to find their students information?

Thanks for the help!



1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Aug 20, 2010 at 08:35 AM
From what I got from your question is that you have information for all in one place and then you want to see information for one person "on demand"
If that is correct, then the best way would be use a macro that can help you to find the information. Least path to resisitance is use filter on sheet
0