Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Excel Tab Linkage (https://www.askmehelpdesk.com/showthread.php?t=417044)

  • Nov 18, 2009, 01:42 AM
    gonbe_88
    Excel Tab Linkage
    It's about excel tab linkage.

    In a same file with a few tabs below,a master tab n a few sub-tabs. What is the way to link the master tab to the sub-tabs? In such a way that, any changes in the master tab will automatically update into the particular sub-tab in a particular cell?? Reply ASAP!! Thx...
  • Nov 18, 2009, 06:33 AM
    ScottGem

    =cell-ref I.E. = Sheet1!B1

    So if the master has a value in B1 then updating the value will change the value of a cell that has that formula in it.

    By the way it usually works the opposite way. The individual sub sheets feed the master, not the other way around.

  • All times are GMT -7. The time now is 04:57 AM.