Hey Everyone,
I have set up an Excel sheet to keep track of our softball stats. I have a separate worksheet for each week, I then have a worksheet that is a total for the entire season. What I am looking to do is on a new worksheet rank the players in descending order for the various stats. We have 13 players on the team.
I found some VBA code that would auto sort two columns but the columns had to have actual values in them not equations.
On my "total season" work sheet all of the cells are a sum or average of the 10 other worksheets.
On a new worksheet I would like to have say 8 tables (2 colums, name of player and specific stat) I would like these 8 tables to auto sort data from the "total season" worksheet in a descending order so when I enter the weekly stats it will update my "total season" worksheet and then automatically resort the 8 or so tables.
Example
Total Season Worksheet (sum of 10 other worksheets)
Name AVG SLG OBP 1B 2B 3B HR
Joe .500 .560 .400 2 3 2 1
Bill .300 .800 .460 1 2 2 4
Andy .800 1.000 .750 8 1 0 0
Worksheet with tables
Top Average
Andy .800
Joe .500
Bill .300
Top Slugging
Andy 1.000
Bill .800
Joe .560
and so on...
Any ideas on how to automatically sort data from another worksheet and the data on that worksheet is actually just equations summing data from other worksheets. Also the columns that need to be sorted are not side by side.
Any insight would be great.
Thanks,
Drew
I have set up an Excel sheet to keep track of our softball stats. I have a separate worksheet for each week, I then have a worksheet that is a total for the entire season. What I am looking to do is on a new worksheet rank the players in descending order for the various stats. We have 13 players on the team.
I found some VBA code that would auto sort two columns but the columns had to have actual values in them not equations.
On my "total season" work sheet all of the cells are a sum or average of the 10 other worksheets.
On a new worksheet I would like to have say 8 tables (2 colums, name of player and specific stat) I would like these 8 tables to auto sort data from the "total season" worksheet in a descending order so when I enter the weekly stats it will update my "total season" worksheet and then automatically resort the 8 or so tables.
Example
Total Season Worksheet (sum of 10 other worksheets)
Name AVG SLG OBP 1B 2B 3B HR
Joe .500 .560 .400 2 3 2 1
Bill .300 .800 .460 1 2 2 4
Andy .800 1.000 .750 8 1 0 0
Worksheet with tables
Top Average
Andy .800
Joe .500
Bill .300
Top Slugging
Andy 1.000
Bill .800
Joe .560
and so on...
Any ideas on how to automatically sort data from another worksheet and the data on that worksheet is actually just equations summing data from other worksheets. Also the columns that need to be sorted are not side by side.
Any insight would be great.
Thanks,
Drew
Last edited: