+ Reply to Thread
Results 1 to 2 of 2

Linking workbooks

  1. #1
    Registered User
    Join Date
    08-10-2009
    Location
    Norwich, England
    MS-Off Ver
    Excel 2003
    Posts
    1

    Lightbulb Linking workbooks

    Hi there,

    I've got two shared workbooks A & B working in a network.

    How can I link the cells in both workbooks, so the changes in "A" will be reflected in "B" and the changes in "B" will be reflected in "A"?

    Regards

    Pablo
    Pablo

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Linking workbooks

    How can I link the cells in both workbooks, so the changes in "A" will be reflected in "B" and the changes in "B" will be reflected in "A"?
    Let's say in Book1 you want Sheet1!A1 to equal the same cell in sheet1 of Book2. In Book1, sheet1, cell A1, use this:

    =[Book2]Sheet1!$A$1
    Book1 will reflect the changes made in Book2 for all linked cells.

    Is this what you are after?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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