Subhash wants to make changes in either the source or copied data and have it reflected in the other place. A little bit of VBA makes this possible.
The code from the video:
Private Sub Worksheet_Change(ByVal Target As Range)
MirrorCell = False
Select Case Target.Address
Case “$D$3”
MirrorCell = “B7”
Case “$E$3”
MirrorCell = “B8”
Case “$F$3”
MirrorCell = “B9”
Case “$G$3”
MirrorCell = “B10”
Case “$H$3”
MirrorCell = “B11”
Case “$B$7”
MirrorCell = “D3”
Case “$B$8”
MirrorCell = “E3”
Case “$B$9”
MirrorCell = “F3”
Case “$B$10”
MirrorCell = “G3”
Case “$B$11”
MirrorCell = “H3”
End Select
If MirrorCell = False Then Exit Sub
Application.EnableEvents = False
Range(MirrorCell).Value = Target.Value
Application.EnableEvents = True
End Sub