AutoFill a cell with a value

[N1KO]

Hi,

I need to automatically fill a cell with a value from another cell once the
other cell is selected.

I have a list of numbers in column F and I need cell H2 to equal which ever
cell is selected or even double clicked (if that's possible).

Is there any way of doing this?

Thanks in advance

 

[Stefi]

Install this event macro:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Cancel = True
If Target.Column = 6 Then Range("H2") = Target
End Sub

Regards,
Stefi

„N1KO†ezt írta: