= function - can data be changed in both places?
 

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?

= function - can data be changed in both places?
 

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?