+ Reply to Thread
Results 1 to 5 of 5

Linking and updating data from a master sheet to sheets in other files

  1. #1
    Registered User
    Join Date
    12-14-2011
    Location
    NH
    MS-Off Ver
    Excel 2010
    Posts
    83

    Linking and updating data from a master sheet to sheets in other files

    I have a "master" sheet that will be copied and used for different customers and kept in separate files locations.
    When data changes I would like to make the change on one sheet and have it update all the other sheets.
    I would like to know how to set up the Master Sheet and link the other sheets to it.
    At this point the other sheets do not exist. Only the master.

    Attached is a small sample of the master. What are the next steps?

    Thank you in advance.
    StreekyD
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    03-07-2012
    Location
    Albany, Oregon
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Linking and updating data from a master sheet to sheets in other files

    I too would like to know the answer to this question...

    ie, I want my master workbook with multiple sheets to up-date and change the same single tab in another workbook (can I link the tab in the master to the tab in the other?). Both are the exact same information right now. I have to break out the sheets so that different users can view their data. I am SO tired of up-dating multiple data sheets in different workbooks! HELP!

  3. #3
    Registered User
    Join Date
    12-14-2011
    Location
    NH
    MS-Off Ver
    Excel 2010
    Posts
    83

    Re: Linking and updating data from a master sheet to sheets in other files

    There is a link in the paste option that has a chain. once you find that you will be able to link between all office docs.

    So you highlight and copy what you want to link, even an entire spread sheet then go to your new sheet and right click go to paste special, look for thre chain and use that to paste your link. Any thing you do on the master will change on the linked sheet.
    This is wwhat I learned. I am sure there are other ways to do this. I do not know about multiple sheet or docs.

    HTH

  4. #4
    Registered User
    Join Date
    03-07-2012
    Location
    Albany, Oregon
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Linking and updating data from a master sheet to sheets in other files

    This works great on my desk top versions. If I put a link to the copy on the server and the user opens it to view the updates (or just opens it at all) it gives a NULL error report in each cell.

  5. #5
    Registered User
    Join Date
    12-14-2011
    Location
    NH
    MS-Off Ver
    Excel 2010
    Posts
    83

    Re: Linking and updating data from a master sheet to sheets in other files

    Maybe you have to hyperlink it?

    This is a little beyond me.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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