+ Reply to Thread
Results 1 to 3 of 3

Linking a Large Quantity of Cells from Multiple Workbooks

  1. #1
    Registered User
    Join Date
    01-03-2014
    Location
    San Francisco
    MS-Off Ver
    Excel 2013/Office 365
    Posts
    13

    Linking a Large Quantity of Cells from Multiple Workbooks

    I have three separate workbooks "Audits One," "Audits Two" and "Audits Three" and I am trying to compile the data that exists within those three workbooks into one master workbook "Compiled Audits." The three Audit workbooks are formatted exactly the same except that they have a different number of "active" columns in them because the "Auditors" don't have the same number of Audits.
    I tried doing the whole click in the cell of the "Compiled Audits" Workbook <="click in desired cell of audit workbook"> but there are probably thousands of cells and I would rather not go to my grave pressing equal, click, click, enter.
    I have tried dragging the cells but they don't update the link.
    Is there a macro or quick way to make this happen?
    I would like the "Compiled Audits" to update whenever the "audit" files are updated without all of them having to be opened.
    I have attached an example Compiled Audits workbook and an Audit workbook (there will be three but I figured one is enough for an example).


    Compiled Audits Safe Test.xlsx
    Audits Safe Test.xlsx


    Thank you in advance for any help! It is much appreciated.
    Last edited by Switchedit; 03-07-2014 at 09:51 PM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Linking a Large Quantity of Cells from Multiple Workbooks

    Your file/sheet names dont quite match with what you described, and maybe you could include a sample of your expected outcome? (remember, you know exactly what you are working with and what you want, we dont)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    01-03-2014
    Location
    San Francisco
    MS-Off Ver
    Excel 2013/Office 365
    Posts
    13

    Re: Linking a Large Quantity of Cells from Multiple Workbooks

    Thanks for responding FDibbins!

    So I have edited the post, hopefully I made it more clear but I'll try again too.

    I have Three Workbooks: "Audits Bob", "Audits Joe" and "Audits John".
    Bob will only have four audits, Joe twenty and John ten lets say (these all exist on the same sheet, not four, twenty and ten sheets).
    Each of them will have their own workbooks. The portion of the workbook that Bob, Joe and John will be editing is the portion that is not frozen. The frozen panes will not really be edited other than to enter the date and store name, the items in the first three columns will not change between Bob, Joe and John.

    I would like all of the Audit workbooks to feed into one "Compiled Audits Workbook" onto one Sheet in that Workbook.

    Here is what I would ultimately want it to look like:
    Example Finished Compiled Audits Test.xlsx

    "Joe" and "Bob" Workbooks:
    Audits Safe Bob Test.xlsx
    Audits Safe Joe Test.xlsx

    Empty Compiled Audits Workbook:
    Compiled Audits Safe Test.xlsx


    Hopefully this is more clear! Thanks again for any help!

+ 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. Linking cells to multiple workbooks
    By sk88 in forum Excel General
    Replies: 3
    Last Post: 07-30-2013, 12:27 PM
  2. Linking Multiple Workbooks
    By 4blue in forum Excel General
    Replies: 10
    Last Post: 09-16-2009, 01:58 AM
  3. Excel 2007 : Linking multiple workbooks...
    By JohnG89 in forum Excel General
    Replies: 3
    Last Post: 09-15-2009, 11:06 AM
  4. [SOLVED] linking to multiple workbooks
    By cwwolfdog in forum Excel General
    Replies: 4
    Last Post: 04-18-2005, 01:06 PM
  5. [SOLVED] linking cells in multiple workbooks
    By sherobot in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-31-2005, 09:06 PM

Tags for this Thread

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