Hi Doyle,

Even merging two adjacent cells do not operate like that.

The only way you would be able to effect that change quickly
would be with a Change Event macro and would apply to
constants only not to formulas. I did not check as constant in my example.
http://www.mvps.org/dmcritchie/excel/event.htm#change

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
'to install -- right-click on the sheettab of the sheet to
' be used in and choose 'view code'. Paste this Worksheet
' event macro into the module.
'-- change to Col B changes value in Column G to that of B
'-- change to Col G changes value in Column B to that of G
On Error GoTo ErrHandler
Application.EnableEvents = False
If Target.Column = 2 Then
Cells(Target.row, 7).Value = Target.Value
ElseIf Target.Column = 7 Then
Cells(Target.row, 2).Value = Target.Value
End If
ErrHandler:
Application.EnableEvents = True
End Sub

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Doyle_D" wrote in message ...
I would like to see the ability to merge non-adjacent cells. In essence, I
am talking about tying two or more cells together so that they behave like
the same cell: you would be able to change data in EITHER ONE and it will
automatically show up in the other cell AND vice-versa.
--
Doyle_D

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.


http://www.microsoft.com/office/comm...lic.excel.misc