Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Dim i As Integer
If Target.Column = 2 Then
For i = 15 To 70
If Target.Row = i Then
[F6] = ActiveCell.Value
[C6] = Cells(Target.Row, "C")
[D6] = Cells(Target.Row, "D")
End If
Next i
End If
End Sub