+ Reply to Thread
Results 1 to 2 of 2

Merging sheets in multiple workbooks into a Master woorkbooks that updates

  1. #1
    Registered User
    Join Date
    03-26-2020
    Location
    NC
    MS-Off Ver
    16
    Posts
    1

    Merging sheets in multiple workbooks into a Master woorkbooks that updates

    I need help. I have a workbook assigned to 4 different consultants. They collect the same type of information. Some consultants will have more than others in each tab. The consultants may update their workbooks daily or weekly. There are two tabs, Referrals and Randoms, for each consultant.

    I would like to know if I can merge the data from each workbook into a master workbook for our lead consultant. Each time the lead consultant opens the workbook it updates with any changes the 4 consultants make in their own workbooks. Also, if the lead consultant could also edit in the master workbook that would be great.

    I have attached a sample of the master workbook.

    Thank you for any help!
    Attached Files Attached Files

  2. #2
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,888

    Re: Merging sheets in multiple workbooks into a Master woorkbooks that updates

    If the workbooks are maintained in the same folder, then this is an easy exercise in Power Query.

    https://www.myexcelonline.com/blog/c...g-power-query/
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. merging sheets in different workbooks into a master sheet
    By bardosi.m in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-27-2015, 12:44 PM
  2. Merging tables from multiple workbooks into one master list no breaks
    By winwall in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-04-2014, 02:28 PM
  3. Linking Source Woorkbooks to Master Workbooks
    By Gittelman in forum Excel General
    Replies: 0
    Last Post: 07-10-2014, 05:18 AM
  4. [SOLVED] Merging 1 worksheet from multiple workbooks into a master workbook
    By neato in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-09-2014, 01:47 PM
  5. Merging multiple workbooks on to one master workbook
    By inkandpaint in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-15-2012, 01:22 PM
  6. Merging multiple workbooks (with multiple worksheets) in to one master sheet
    By inkandpaint in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-22-2012, 09:46 AM
  7. [SOLVED] Merging multiple workbooks into one master workbook
    By sumichung@gmail.com in forum Excel General
    Replies: 2
    Last Post: 05-26-2006, 01:35 AM

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