Mirror two cells between worksheets and edit either way

Hello ExPanRider and welcome to the forum.

You haven't provided a sample file so I can only offer general guidance.

Let's assume the cell you edit is C3 on Sheet1 and the mirror cell is F5 on Sheet2.

In F5 on Sheet2 enter this: =('Sheet1'!C3) .

Obviously you will need to edit the sheet name and/or cell reference to match your situation.

See attached file for example.

Updated June 1 @ 11:10

I have attached Mirror Cell V2 (modified version of the original file) which uses Worksheet_Change event code. I figured out how to prevent the endless loop I  decribed in discussion below. The V2 file achieves what you are looking to do.

Sheet1 code:

Private Sub Worksheet_Change(ByVal Target As Range)

' macro written by WillieD24 for teachexcel.com

If Range("C3") = Sheet2.Range("F5") Then Exit Sub

If Target = Range("C3") Then
' both of the following lines will do the same thing
    Sheet2.Range("F5") = Sheet1.Range("C3")
    'Sheet1.Range("C3").Copy Sheet2.Range("F5")
End If

End Sub

Sheet2 code:

Private Sub Worksheet_Change(ByVal Target As Range)

' macro written by WillieD24 for teachexcel.com

If Range("F5") = Sheet1.Range("C3") Then Exit Sub

If Target = Range("F5") Then
' both of the following lines will do the same thing
    'Sheet1.Range("C3") = Sheet2.Range("F5")
    Sheet2.Range("F5").Copy Sheet1.Range("C3")
End If

End Sub

If this is what you were looking for please mark my answer as selected.

Cheers   :-)