Results 1 to 3 of 3

Dynamically update tables in multiple sheets from master table

Threaded View

  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

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