+ Reply to Thread
Results 1 to 4 of 4

Summarizing data from multiple sources

Hybrid View

  1. #1
    Registered User
    Join Date
    11-16-2015
    Location
    Michigan City, Ind
    MS-Off Ver
    2013
    Posts
    2

    Re: Summarizing data from multiple sources

    I have attached 2 workbooks. In "Small Line 2018" the assemblers will record their daily finishes. As you can see there is a worksheet for each month. The only data that I am currently interested in is the "Daily Completions". They will enter the daily completions in row 8 under the appropriate day of the month. There are 3 assembly workbooks: Small Line 2018.xlsx, Medium Line 2018.xlsx, and Large Line 2018.xlsx. These 3 workbooks will reside in the same folder. I only attached 1 of the 3. The attachment "Daily Productivity.xlsx" is the management workbook that will contain the summary data. The date is displayed in C1. This management summary will expand as our new processes are being developed. all I care about at this time is the 4 pieces of data coming from each of the individual assembly workbooks and populating the management summary. I hope this gives what you need. Again, thank you very much for your help.
    Attached Files Attached Files

+ 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] Looking At Multiple Data Entries and Summarizing Them
    By AmberLeanne in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-18-2017, 10:04 PM
  2. Summarizing certain data from multiple worksheets
    By Jeleine in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-14-2016, 11:16 AM
  3. [SOLVED] Connect multiple pivots (with multiple data sources) to one slicer
    By jeroenft in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-24-2015, 07:29 PM
  4. [SOLVED] Connect multiple pivots (with multiple data sources) to one slicer
    By jeroenft in forum Excel General
    Replies: 1
    Last Post: 08-24-2015, 04:49 AM
  5. [SOLVED] Summarizing data from multiple sections
    By tuppari in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-22-2012, 07:04 AM
  6. VBA Pivot Table - Multiple Tables - Multiple Sources of Data
    By ryanmorris in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-08-2012, 03:13 PM
  7. Replies: 0
    Last Post: 12-12-2011, 07:27 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