Auto Change Formula in different sheets

  • Thread starter Thread starter Ice Man
  • Start date Start date
I

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
 
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
 
Back
Top