Nikki
Only through event code.
See this google search thread for sample code.
http://tinyurl.com/ynw86x
Gord Dibben MS Excel MVP
On Mon, 6 Aug 2007 14:10:00 -0700, Nikki
wrote:
Hi,
I have a master sheet that has all of my data and then separate tabs that
only have certain data. Currently I have been using the = function to get
the data from the master sheet to appear on the other sheets. Is there a way
that I can make it so that I can change data in either place (master sheet or
tabs) and the related data in the other place updates automatically?