Auto Change Formula in different sheets
 

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

Auto Change Formula in different sheets
 

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


-----Original Message-----
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


.