+ Reply to Thread
Results 1 to 2 of 2

Create a workbook that dynamically consolidates data from multiple workbooks

  1. #1
    Registered User
    Join Date
    03-20-2015
    Location
    Valencia, CA
    MS-Off Ver
    2010
    Posts
    4

    Create a workbook that dynamically consolidates data from multiple workbooks

    I am trying to create a "Master" workbook that consolidates data from mulitple workbooks. Each workbook has the same data format. Can someone tell me how to create this link between workbooks that are located on the same network location?

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Create a workbook that dynamically consolidates data from multiple workbooks

    'WORKBOOKS TO 1 SHEET STACKED
    Here's a macro for collecting data from all files in a specific folder.

    The parts of the code that need to be edited are colored to draw your attention.
    Last edited by JBeaucaire; 12-26-2019 at 04:10 PM.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

+ 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. Replies: 3
    Last Post: 11-23-2015, 06:27 PM
  2. [SOLVED] Adjust a macro that consolidates data from multiple workbooks
    By dreddster in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-25-2015, 03:16 AM
  3. [SOLVED] create multiple workbooks from a single workbook
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-07-2013, 02:36 AM
  4. Create and Label Multiple Workbooks Using Data From Master Workbook
    By ChrisAnthony in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-23-2013, 11:07 AM
  5. Replies: 8
    Last Post: 06-07-2012, 05:14 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