I've taken a look through a number of different forums, MSDN, etc. and haven't been able to track down an answer. Perhaps what I'm searching for isn't the correct terminology. I have a number of master tables on one sheet named "Master Roster". Each table has been named. What I'd like to do is update tables on all my other sheets based on the master tables. As information is added or removed, new rows will need to be added/removed from all of the other tables. I have attached an example file. There will be additional tables on the other sheets that correspond with the master tables, I just included one example for now so I can learn and work from there. For the purposes of this example, the master table is Servers and the tables on each day is Lunch_Servers_DayX where X corresponds with the day number. I don't care if VB or simple formulas are used, or if I could even figure out how to use a data model with Power Pivot. Any help would be greatly appreciated.
Bookmarks