Thread: Link Formulae
View Single Post
  #2   Report Post  
Ken Johnson
 
Posts: n/a
Default

Chandra,
the only way I know of is to use a Worksheet_Change Event procedure.
Using your example the following worked for me

Private Sub Worksheet_Change(ByVal Target As Range)
Sheets(2).Range("A6").Formula = ActiveSheet.Range("A6").Formula
End Sub

I put this Sub into the Sheet 1 module.

It only works one way. The formula on Sheet 2 changes when you change
the formula on sheet 1, but not the other way around.

Hope this helps
Ken Johnson