Copy and Autochange Excel Function not the Value

[austinandrei]

Hi,
I have several sheets in a workbook that has same source formula.
Say in Sheet1:
Column C has a formula of "=A1+B1"
Is it possible to copy the formula, not the result of "=A1+B1" in all sheets and when you change the formula in Sheet1, the other sheets would automatically change also.
Thanks

 

[ozbod]

Try Paste Special... Formulas which tends to auto adjust on a relative reference aspect

 

[austinandrei]

But for Paste Special, it will only copy the formula once.
I need something that says like:
Sheet2!C3="=Sheet1!C3 "formula""
Whenever I change the formula in Sheet1!C3, the C3 in other sheets will automatically change their formula also.
Is that even possible? I know its possible using VBA codes, but for plain Excel formula, would that be possible?