MooseComms
New Member
- Joined
- Sep 24, 2020
- Messages
- 2
- Office Version
- 365
- Platform
- MacOS
Hi Folks,
I've been working on a large "statbook" for a sports team and am pretty happy with where I'm at. Basically we enter some data from the game and it spits out a large amount of situational stats in a number of tables.
I'm nearly done, but the last hurdle I've run into is refreshing the tables when a new player is added.
The way it is set up, there is one table on a worksheet where players are added. There are about 50 rows and wherever there isn't a player, the cell is labeled "place holder". The stat tables then reference this master list so we only have to update the players in one spot. Unfortunately this means we need to run a filter to keep things clean and since they don't auto-update I'm looking to do the following.
Either get the sheets auto-updating the filters, or build a macro that will refresh all the filters in the work book. I tried recording a macro... but naturally it was too large to run. I've tried a few of the code snippets I've found online, but I think I'm running into problems because of the tables referencing that main list. I've been able to make a macro for one page to reapply the filter, but would prefer to not have to refresh all 20ish worksheets.
Any tips would be greatly appreciated! Thanks!!
*Screenshots attached represent the utility/master list and a look at two of the tables with the filter applied*
I've been working on a large "statbook" for a sports team and am pretty happy with where I'm at. Basically we enter some data from the game and it spits out a large amount of situational stats in a number of tables.
I'm nearly done, but the last hurdle I've run into is refreshing the tables when a new player is added.
The way it is set up, there is one table on a worksheet where players are added. There are about 50 rows and wherever there isn't a player, the cell is labeled "place holder". The stat tables then reference this master list so we only have to update the players in one spot. Unfortunately this means we need to run a filter to keep things clean and since they don't auto-update I'm looking to do the following.
Either get the sheets auto-updating the filters, or build a macro that will refresh all the filters in the work book. I tried recording a macro... but naturally it was too large to run. I've tried a few of the code snippets I've found online, but I think I'm running into problems because of the tables referencing that main list. I've been able to make a macro for one page to reapply the filter, but would prefer to not have to refresh all 20ish worksheets.
Any tips would be greatly appreciated! Thanks!!
*Screenshots attached represent the utility/master list and a look at two of the tables with the filter applied*