Can two cells contain the same information?

  • Thread starter Thread starter Kristian
  • Start date Start date
K

Kristian

Hey. Is this possible:
Say that I want cells A2 and A3 to contain the same info.

Example
When I enter the number 50 in A2 the number 50 will also appair in A3.
Vice versa; when I enter 51 A3, 51 will also appair in A2.

Is this at all possible?

Thanks!
 
Hi Kristian
one way woul be using a worksheet event (the worksheet_change event).
This is not possible with formulas. You may try the following macro
(put this in your worksheet module):

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.count > 1 Then Exit Sub
If Intersect(Target, Me.Range("A1:A2")) Is Nothing Then Exit Sub
On Error GoTo CleanUp:
With Target
Application.EnableEvents = False
If .Address = "$A$1" Then
.Offset(1, 0).Value = .Value
Else
.Offset(-1, 0).Value = .Value
End If
End With
CleanUp:
Application.EnableEvents = True
End Sub
 
Back
Top