Linking Cells Together

[bamaisgreat]

Is ther away to link a cell from one sheet to another and be able to enter data in either cell and it update the other ?!

Thanks as always

 

[Gilliam]

Something like this will help to get you started...

Private Sub Worksheet_Change(ByVal Target As Range)
    Select Case Target.Address
    Case "$A$1"
        Sheets(2).Range(Target.Address).Value = ActiveSheet.Range("A1").Value
    Case "$A$2"
        Sheets(2).Range(Target.Address).Value = ActiveSheet.Range("A2").Value
    End Select
End Sub

Cheers.