Friends

Is there any way in excel in which i could link the formula and not copy
them. Meaning I want to link the formulae in such a way that the formula of
the linked cell changes if there is a modification of the formula of the
parent cell.


I have elaborated by giving an example

Say I have a formula sum(A1:A5) in the cell A6 in worksheet1.
I copy the similar formula in worksheet2 at A6

Now I want the formula in worksheet2 to change if I have changed the formula
in worksheet1.

For example

If the formula in Worksheet1 A6 is changed to sum(A1:A4) , I want the
formula in Worksheet2 A6 to change automatically to sum(A1:A4)

Any Ideas how to do this in Excel.

--
Regards

Chandra