Auto Change Formula in different sheets

[Ice Man]

Hi all

I got an excel workbook with 11 sheets with the same structure
I want that when a formula is changed in 1 sheet automatiocally be changed
in other sheets

Is there a way doing this without (Copy-Paste Special- Only Formulas)

thanks

 

[Abdul Salam]

The follwing code will give you a start..

use a loop to go thru all you sheets and define range of
cells to be changed

Sub test()
Sheets("sheet2").Range("c1").FormulaR1C1 = Sheets
("sheet1").Range("C1").FormulaR1C1

End Sub

Abdul Salam