+ Reply to Thread
Results 1 to 2 of 2

Summary workbook from multiple workbooks in same folder

  1. #1
    Forum Contributor
    Join Date
    07-12-2015
    Location
    Dubai,UAE
    MS-Off Ver
    2007,Office 365
    Posts
    344

    Summary workbook from multiple workbooks in same folder

    Dears,

    I am trying to generate a workbook showing summary of progress over weeks.
    The individual workbooks ( excluding summary) will be named as per the date on weekly basis. For Eg 12-5-19
    19-5-19
    26-5-19 etc.
    All individual workbooks will have a table showing progress of items in the following format:

    Structure : 50%

    Finishes : 20%

    MEP : 15%



    In the summary workbook, there will be a table in the following format:

    12-5-19 19-5-19 26-5-19 2-6-19 ... & so on
    Structure : 50% 50% 50% 50%

    Finishes : 20% 20% 20% 20%

    MEP : 15% 15% 15% 15%


    What I'm trying to achieve

    In the summary workbook, I will be populating the date row manually upto the last date I require.

    For the 1st week ( 12-5-19), I will update the individual file and place it in the same folder.

    For the next week, I will copy 12-5-19 , rename it to 19-5-19 , update progress and place it in same folder.

    After that , I need these values from 19-5-19 workbook to automatically appear in summary workbook under column "19-5-19"

    And so on for all other weeks..

    I cannot use VBA and would require a formula solution.



    Thanks in advance..

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    9,171

    Re: Summary workbook from multiple workbooks in same folder

    Perhaps this tutorial video will be of some help in generating a summary workbook from multiple workbooks using Power Query. The portion of the video that deals with importing files begins at the 21:55 mark, after the commercial has played.
    Edit: Here is another link to a tutorial that addresses the subject of Combining Data from Multiple Workbooks in Excel (using Power Query)
    Best of luck.
    Last edited by JeteMc; 05-15-2019 at 04:13 PM. Reason: Added second link
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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