Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo Fin
If Target.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("W12")) Is Nothing Then
If Target <> "OFF" Then
For L = 12 To 19
Cells(11 + Target, 35 + L - 12) = Cells(L, "AD")
Cells(11 + Target, 44 + L - 12) = Cells(L, "AF")
Cells(11 + Target, 53 + L - 12) = Cells(L, "AG")
Next L
End If
End If
Fin:
End Sub
=SIERREUR(TRANSPOSE(--(""&$AD$12:$AD$19))/($W$12=LIGNE()-11);"")