Bonjour,
copier cette macro sur la page code de la feuille,
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Set isect = Application.Intersect(Target, Range("D3:K14"))
If Not isect Is Nothing Then
If Cells(Target.Row, 3) = "A" Then Cells(Target.Row, 3) = "" Else Cells(Target.Row, 3) = "A"
If Cells(2, Target.Column) = "A" Then Cells(2, Target.Column) = "" Else Cells(2, Target.Column) = "A"
Cells(3, "N") = Cells(Target.Row, 2).Value
Cells(4, "N") = Cells(1, Target.Column).Value
End If
End Sub
est ce que ça convient ?