Bonjour à tous!
Nonno, code à placer dans la feuille Bon
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Not Application.Intersect(Target, Range("Q6:Q36")) Is Nothing Then
Target.Copy Destination:=Range("E" & Rows.Count).End(xlUp).Offset(1, 0)
End If
End Sub
Bonne journée!