nuke_twidget
New Member
- Joined
- Apr 13, 2016
- Messages
- 26
I'm in the process of redoing a dashboard and I've gotten the main layout done as well as all of the formulas. One of the things I'm running in to is a problem updating tables across multiple sheets. Here's the predicament:
- The main sheet holds a list of names broken down into 6 different roles that they can perform (the master roster)
- There are 14 additional sheets with a summary of activities that correspond to the master roster
As of now, as names are added / removed to the master roster, all 14 sheets have to be manually changed to reflect the changes in the master roster. The ultimate goal is to add or remove names to the master roster and have the name added or removed from all of the tables in the 14 other tabs. I'd like to use tables so it automatically populates all of the formulas as well. I'll then be inserting a macro to auto sort every table alphabetically and then creating named ranges to perform a summary lookup. Thanks in advance for your help!
- The main sheet holds a list of names broken down into 6 different roles that they can perform (the master roster)
- There are 14 additional sheets with a summary of activities that correspond to the master roster
As of now, as names are added / removed to the master roster, all 14 sheets have to be manually changed to reflect the changes in the master roster. The ultimate goal is to add or remove names to the master roster and have the name added or removed from all of the tables in the 14 other tabs. I'd like to use tables so it automatically populates all of the formulas as well. I'll then be inserting a macro to auto sort every table alphabetically and then creating named ranges to perform a summary lookup. Thanks in advance for your help!
Last edited:
