+ Reply to Thread
Results 1 to 3 of 3

Auto Populate Master Sheet from Multiple Other Workbooks

  1. #1
    Forum Contributor
    Join Date
    06-21-2010
    Location
    -
    MS-Off Ver
    Excel 2010
    Posts
    1,211

    Auto Populate Master Sheet from Multiple Other Workbooks

    I have people updating four different workbooks and I want this information to automatically be updated in a separate master workbook every time the master is opened.

    I found on this forum a perfect example of what I'm trying to achieve, the only problem is that it assumes the individual sheets being updated reside in the same workbook (see attached file). The functionality is perfect using this code, however I would need the ability to define which sheet in the workbooks the data is taken from as there will be more than one.

    How can I adapt the code to accommodate the workbooks being separate to the master file I need to update. The individual workbooks can all be located in the same folder, though it would be neater to be able to define the path to each so they can reside in different folders.

    Many thanks for any help

    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,173

    Re: Auto Populate Master Sheet from Multiple Other Workbooks

    Once all your required excel files are open , save the 'group' using Save Workspace.
    On the View tab, in the Window group, click Save Workspace.

    Open the wrkspc and ALL sheets will re-open and then you can run your update. (But I wouldnt put it in Activate..I'd have it in its own macro name)

  3. #3
    Forum Contributor
    Join Date
    06-21-2010
    Location
    -
    MS-Off Ver
    Excel 2010
    Posts
    1,211

    Re: Auto Populate Master Sheet from Multiple Other Workbooks

    Hi ranman256,

    I don't have control over the other worksheets and they will all be updated at random times, so your solution isn't really viable. Did you look at the sample I uploaded, that provides the exact functionality I'm looking for only I need this to work for different workbooks rather than sheets within the same workbook as per the sample...

    Many thanks

+ 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. Want to auto populate an excel sheet from a master sheet of data
    By M>E> in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-07-2014, 03:34 PM
  2. Auto-populate to Master list from Multiple sub sheets
    By 614984 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-18-2012, 04:18 PM
  3. Auto populate to master worsheet from multiple workbooks and...
    By ken carlson in forum Excel Programming / VBA / Macros
    Replies: 47
    Last Post: 10-13-2011, 11:15 AM
  4. Auto Populate Master Sheet with multiple sheets data
    By haley in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-26-2009, 04:29 AM
  5. how to auto populate data from multiple sheets to a master
    By Fosachy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-21-2009, 06:15 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