Make a cell reflect the content of whatever other cell

[edge37]

Hello, I need to use a VLOOKUP formula and I require to define one cell that reflects the content of any other cells when I click on them. Example: if cell A1 has a name: ARTHUR, I need that same name to appear in the reflecting cell, if I click on cell A2 with JOHN, it now gets reflected in that same cell, etc.

Thanks in advance

 

[shg]

It would require VBA -- you good with that?

EDIT: Also, it would kill Undo, which is a pretty high price, IMO.

 

[edge37]

Im not good with VBA. Can you give me a hint on what to do? Thanks

 

[shg]

In the worksheet module,

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  With Target(1)
    If Not IsEmpty(.Cells) Then Range("F2").Value = .Value
  End With
End Sub

Change F2 to wherever you want the result to appear.

 

[edge37]

Thanks, will try.

 

[shg]

That should be

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  With Target.Cells(1)
    If Not IsEmpty(.Cells) Then Range("F2").Value = .Value
  End With
End Sub

 

[edge37]

Thanks, will try