PDA

View Full Version : Excel Tab Linkage


gonbe_88
Nov 18, 2009, 01:42 AM
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...

ScottGem
Nov 18, 2009, 06:33 AM
=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.