+ Reply to Thread
Results 1 to 1 of 1

Excel Master/Slave Workbooks - External Links

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2016

    Excel Master/Slave Workbooks - External Links

    OK friends, here's what I am working on:

    I have a spreadsheet at work that we use to keep track of every lot of parts we build. We have a table that has one lot number per row. Each column has different information about the lot, as well as if a certain manufacturing step has been completed. (1 for complete, 0 for incomplete) Currently I am manually updating each finished manufacturing step for all departments. (four departments) Here's a simplified version of the table:

    Lot Number Start Date Material Machining Inspection Work Order
    0001 8/9/16 1 1 0 1
    0002 8/10/16 1 1 0 1
    0003 8/11/16 1 1 0 1
    0004 8/20/16 1 0 0 1

    What I want is for there to be one master workbook that includes all of this data, which is pulled from workbooks from each department.
    In other words, lot numbers and start dates will be manually updated in the master workbook, and the other machining steps will populate from data in each of the department workbooks.
    The department workbooks need to have a table linked to the master workbook that shows them the lot number and start dates, and then the master will update their respective column as they fill in their completed machining step for each lot.

    The grand product will be five workbooks, (the master, material department, machining department, inspection department, and work order department) that link to each other.

    Notes: The lot numbers shift order and change on a daily basis. We typically have 400-500 lots on our schedule.
    Last edited by Yakov on Excel; 08-09-2016 at 03:44 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. [SOLVED] Need macro to merge data from external workbooks into one master
    By sirhacksalot in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 09-18-2013, 11:18 AM
  2. Changing Master workbook automatically changes all Slave workbooks
    By silencer2000 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-07-2011, 10:58 AM
  3. Update external workbooks with changes made in master workbook
    By colton in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-01-2010, 01:15 PM
  4. Master and slave workbooks
    By Lizzietish11 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 10-31-2009, 02:21 PM
  5. Identifying workbooks with links to external file
    By Barb Reinhardt in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-28-2006, 05:35 PM
  6. Shade cells with links to external workbooks
    By Steph in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-06-2005, 04:05 PM
  7. [SOLVED] how do I activate links without opening external workbooks?
    By teh_chucksta in forum Excel General
    Replies: 0
    Last Post: 08-29-2005, 07:05 PM
  8. Links to external workbooks
    By grime in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-01-2005, 01:07 AM

Tags for this Thread


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