Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2005

    Unanswered: Consolidate Information


    I am new here and I am also very limited in my understanding of excel (I know basic and some beyond basic). I am wondering if it's possible to consolidate information from 3 seperate regional workbooks into one master workbook. I would like to be able to go to the master workbook and make changes in a section that would be linked to the corresponding area in one of the regional workbooks, making the same change to both workbooks; and vice versa from the regional workbook to the master workbook. Obviously the master workbook won't be using the exact same cells that the regional workbooks will be for the same information. I know you can do this from one worksheet to another worksheet, but I need to do it from one workbook to another. Any help will be most appreciated.


  2. #2
    Join Date
    Oct 2003
    Welcome to the board!

    You can take a look at this approach:

    Consolidate Workbooks
    old, slow, and confused
    but at least I'm inconsistent!

    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts