hudsonhacker
New Member
- Joined
- Mar 10, 2011
- Messages
- 6
Hi All
I am putting together a spreadsheet to track stats in our baseball league. I have each players stats on sheet 1. I want to rank the players based on their batting average which is in row I. I would like this ranking to show up on a separate worksheet, sheet 2, ranked in descending order. Pretty simple, but I would like it to re-rank every time I change a players stats on Sheet 1. Basically, I want sheet 2 to update and re-rank every time I make a change on sheet 1.
Seems pretty simple, and there are probably a number of ways to do it, would a macro work?
I am putting together a spreadsheet to track stats in our baseball league. I have each players stats on sheet 1. I want to rank the players based on their batting average which is in row I. I would like this ranking to show up on a separate worksheet, sheet 2, ranked in descending order. Pretty simple, but I would like it to re-rank every time I change a players stats on Sheet 1. Basically, I want sheet 2 to update and re-rank every time I make a change on sheet 1.
Seems pretty simple, and there are probably a number of ways to do it, would a macro work?
