I cant seem to figure out how to make a stats table actually work. (i.e. a league table automatically change when a score is submitted). i have input all the things i need, i now want to save a little bit more time with having a table that automatically updates itself, can anyone please help!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
automatic table
- Thread starter abee4life
- Start date
I cant seem to figure out how to make a stats table actually work. (i.e. a league table automatically change when a score is submitted). i have input all the things i need, i now want to save a little bit more time with having a table that automatically updates itself, can anyone please help!Excel Facts
How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
It sounds to me like a "database function" - dget, dsum, etc. I suggest you have a look in excel help at these functions as they can be pretty useful for stuff like that.
You would probably still need to run a little macro / sort to actually change positions in the table though.
You would probably still need to run a little macro / sort to actually change positions in the table though.
Upvote
0
jimrward
Well-known Member
- Joined
- Feb 24, 2003
- Messages
- 1,830
- Office Version
- 2016
- 2013
- 2011
- 2010
- 2007
- Platform
- Windows
I have numerous examples of automatic league tables using a combination of RANK, INDEX, MATCH etc in response to a number of postings on this forum.
I have sent you a PM (personal message) with my email address in if you want to send me your workbook.
I have sent you a PM (personal message) with my email address in if you want to send me your workbook.
Upvote
0
