Good morning. A buddy and myself are working on a spreadsheet for our fantasy football league. We are doing the NFL.com fantasy games including Perfect Challenge, Weekly Pick'Em, and TNF Challenge. To determine a winner at the end of the year, we are taking all 3 fantasy games and totalizing the scores from each game for each player. The player with the highest score at the end of Week 16 wins. We built the spreadsheet to tally the scores on a summary sheet and we want our chart to update weekly to show the highest score first, descending to the lowest score last. I'm pretty handy with Excel until it comes to conditional formatting or macros and I dont' know how to accomplish what I want. Any ideas?

Thanks! I can upload the spreadsheet if necessary, but its basically a column of names and a column of numbers reflected in a graph. I just need to auto sort them every time we update it.

Jim