+ Reply to Thread
Results 1 to 3 of 3

linking tables from 2 workbooks

  1. #1
    Registered User
    Join Date
    03-26-2008
    Posts
    19

    linking tables from 2 workbooks

    Hi guys

    I have 2 tables in different workbooks that are related, which means if i update the table in the first workbook then the table in the other workbook should get updated automatically.How do i do it,is it possible?
    If not then can i do the same but within a workbook(the 2 tables in 2 different spreadsheets) and how?

    Anybody ,please
    Thanks

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570
    Say you have a source workbook, sourcelink.xls, and a destination workbook, destlink.xls. Then in the destination workbook you would put a formula such as:
    =[sourcelink.xls]Sheet1!$A1

    If both workbooks are open dest will immediately reflect the changes made in source.
    if you open source alone and make changes then close it and open dest you will get a dialog requesting to update from source.

    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    03-26-2008
    Posts
    19
    Quote Originally Posted by protonLeah
    Say you have a source workbook, sourcelink.xls, and a destination workbook, destlink.xls. Then in the destination workbook you would put a formula such as:
    =[sourcelink.xls]Sheet1!$A1

    If both workbooks are open dest will immediately reflect the changes made in source.
    if you open source alone and make changes then close it and open dest you will get a dialog requesting to update from source.

    It works
    Thank you!

+ 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