Sub Macro1()
Dim Plage, i As Byte, OK As Boolean, WD As Worksheet, W1 As Worksheet
Set WD = Worksheets("DONNEES")
Set W1 = Worksheets("Feuil1")
Plage = WD.Range(WD.Cells(5, 1), WD.Cells(5, WD.Cells(5, Columns.Count).End(xlToLeft).Column))
For i = LBound(Plage, 2) To UBound(Plage, 2)
If Plage(1, i) = W1.Range("A1") Then
Col = i
OK = True
Exit For
End If
Next
If OK Then
WD.Cells(6, Col) = W1.Range("B2")
WD.Cells(7, Col) = W1.Range("B3")
Else
MsgBox "date invalide"
End If
End Sub