Hi John,

this can only be done by a VBA module - afaik.

Assuming those two cells are A1 and G1 - try to use this code for the
Worksheet_Change event:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target = ActiveSheet.Range("A1") Then
ActiveSheet.Range("G1") = Target.Value
ElseIf Target = ActiveSheet.Range("G1") Then
ActiveSheet.Range("A1") = Target.Value
End If
End Sub

Did this help you?

Best wishes,
Eric

"John Vickers" wrote:


Hey, I don't know if this is possible or even where the post should be,
but here is what I want to do. Is there a way to have 2 cells that
reference each other, so that when you type in one, the value shows up
in both cells. The catch is that I want to be able to enter data in
either cell, so you can't have a standard reference link. Any ideas on
how to acomplish this?

John Vickers


--
John Vickers
------------------------------------------------------------------------
John Vickers's Profile: http://www.excelforum.com/member.php...o&userid=31551
View this thread: http://www.excelforum.com/showthread...hreadid=512459