Expert: Miguel Zapico - 9/2/2009

Question
Hello Sir,i have same type of data[text]in sheet1 ,sheet2,sheet3,sheet4,sheet5.Sheet1 is my main sheet.i need to track any change in sheet1 to correct automatically the data in sheet2,sheet3,sheet4 and sheet5.
EXAMPLE:
A change in sheet1:A1 will bring changes in sheet2:A1,sheet3:A1,sheet4:A4,sheet5:A5

Thanking in advance for help

Answer
In this case, you can use a formula on the separate sheets that you want to have linked, something like:
=Sheet1!A1
This way, every time that you change the value on Sheet1:A1, it will be changed on the other cells that refer to it.

Hope this helps,
Miguel