Hi, I am new. Apologies for any errors in posting.
Can anybody suggest how to mirror two cells on different worksheets?
I want to be able to edit one cell and the other is updated automatically - and vice versa.
Many thanks.
Hi, I am new. Apologies for any errors in posting.
Can anybody suggest how to mirror two cells on different worksheets?
I want to be able to edit one cell and the other is updated automatically - and vice versa.
Many thanks.
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 :-)