+ Reply to Thread
Results 1 to 3 of 3

Dynamically update tables in multiple sheets from master table

  1. #1
    Registered User
    Join Date
    08-11-2017
    Location
    USA
    MS-Off Ver
    2013
    Posts
    2

    Question Dynamically update tables in multiple sheets from master table

    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.
    Attached Files Attached Files

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Dynamically update tables in multiple sheets from master table

    It's not really clear what you're trying to do with your "master" data. Did you want to use the master tables as data validation lists, for data entry in the corresponding fields of the daily tables? Or something else?
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Registered User
    Join Date
    08-11-2017
    Location
    USA
    MS-Off Ver
    2013
    Posts
    2

    Re: Dynamically update tables in multiple sheets from master table

    The master list will house all of the employees. As that list is updated, it needs to update the "Employee" column in all of the other sheets. In the example sheet, I only included the servers, but I'll be replicating this for all other employee groups as well. As employees are added, all other sheets need to reflect the new employee. The converse is true if an employee is terminated and removed from the master list. The only difference is, when an employee is removed, it needs to delete the entire row in the subsequent sheets versus just leaving a blank row in the table.

    EDIT: Solved it by using linked data sources. Thanks!
    Last edited by chssteakjedi; 08-11-2017 at 11:48 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Automatically Update Master Sheet from multiple other sheets
    By Kyle123456 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-13-2016, 05:01 PM
  2. [SOLVED] Update Master spreadsheet from multiple templates sheets
    By avendi in forum Excel General
    Replies: 5
    Last Post: 08-11-2015, 11:48 AM
  3. [SOLVED] Multiple Sheets that need to update off master sheet HELP!
    By Olympiapools in forum Excel General
    Replies: 17
    Last Post: 11-17-2014, 11:05 AM
  4. Consolidate multiple tables into one master table
    By ceri_w in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-17-2014, 08:01 PM
  5. Replies: 1
    Last Post: 09-09-2013, 08:54 PM
  6. Dynamically Link a Summary Master List to Multiple Worbooks/sheets
    By SeanPratt in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-26-2012, 01:22 PM
  7. multiple sheets that dynamically update
    By wcameron in forum Excel General
    Replies: 5
    Last Post: 05-28-2008, 05:01 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1