On Fri, 16 Nov 2007 06:09:03 -0800, Eric
wrote:

Does anyone have any suggestions on how to do this trick in excel?

Within the cell A1, B1, C1, when I enter a number in one of three cell, such
as 3 in cell A1, then 3 will be automatically display on cell B1 and C1. On
the next step, if I enter 6 in cell B1, then 6 will be automatically display
on cell A1 and C1. On the next step, if I enter 8 in cell C1, then 8 will be
automatically display on cell A1 and B1.
Does anyone have any suggestions on how to do this trick in excel?
Thanks in advance for any suggestions
Eric

Right click on the sheet tab.
Select View Code
Paste the code below into the window that opens:

=======================================
Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
Dim AOI As Range
Set AOI = Range("A1:C1")
Dim c As Range

If Not Intersect(Target, AOI) Is Nothing Then
Application.EnableEvents = False
For Each c In AOI
c.Value = Target.Value
Next c
Application.EnableEvents = True
End If

End Sub
====================================
--ron