View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nikki Nikki is offline
external usenet poster
 
Posts: 184
Default = 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?