Mirrored Cells

[MrExcel]

I am posting this on behalf of a reader....

I need to set up two text cells such that whatever I type into either of them automatically goes into both of them. Any formula I've tried (even using alternate cells as pointers) produces formulas with circular references. How can this be accomplished?

Thanks in advance.

 

[Mudface]

Not sure about a formula, but the following worksheet event code will put whatever's typed in cells in column A into the adjacent cell in column B and vice versa, if that's any help: -

Private Sub Worksheet_Change(ByVal Target As Range)

    Select Case Target.Column
    Case 1
        Cells(Target.Row, 2) = Target.Value
    Case 2
        Cells(Target.Row, 1) = Target.Value
    End Select

End Sub

 

[MrExcel]

To prevent the event handler being called recursively, you should turn off EnableEvents when you change the cells:

Private Sub Worksheet_Change(ByVal Target As Range)

    Application.EnableEvents = False

    Select Case Target.Column
    Case 1
        Cells(Target.Row, 2) = Target.Value
    Case 2
        Cells(Target.Row, 1) = Target.Value
    End Select
    Application.EnableEvents = True

End Sub