Sub Recherche()
Dim mnom As String, mprenom As String, mdate As String
mdate = ThisWorkbook.Sheets("Feuil2").Range("B8").Value
mnom = ThisWorkbook.Sheets("Feuil2").Range("C8").Value
mprenom = ThisWorkbook.Sheets("Feuil2").Range("D8").Value
For i = 1 To ThisWorkbook.Sheets("Feuil1").Range("E65536").End(xlUp).Row
If mdate = ThisWorkbook.Sheets("Feuil1").Range("E" & i).Value And mnom = ThisWorkbook.Sheets("Feuil1").Range("F" & i).Value And mprenom = ThisWorkbook.Sheets("Feuil1").Range("G" & i).Value Then
ThisWorkbook.Sheets("Feuil2").Range("B12").Value = mdate
ThisWorkbook.Sheets("Feuil2").Range("C12").Value = mnom
ThisWorkbook.Sheets("Feuil2").Range("D12").Value = mprenom
ThisWorkbook.Sheets("Feuil2").Range("E12").Value = ThisWorkbook.Sheets("Feuil1").Range("H" & i).Value
ThisWorkbook.Sheets("Feuil2").Range("F12").Value = ThisWorkbook.Sheets("Feuil1").Range("I" & i).Value
ThisWorkbook.Sheets("Feuil2").Range("G12").Value = ThisWorkbook.Sheets("Feuil1").Range("J" & i).Value
Exit For
End If
Next
End Sub
Sub Supprimer()
Dim mnom As String, mprenom As String, mdate As String
mdate = ThisWorkbook.Sheets("Feuil2").Range("B12").Value
mnom = ThisWorkbook.Sheets("Feuil2").Range("C12").Value
mprenom = ThisWorkbook.Sheets("Feuil2").Range("D12").Value
For i = 1 To ThisWorkbook.Sheets("Feuil1").Range("E65536").End(xlUp).Row
If mdate = ThisWorkbook.Sheets("Feuil1").Range("E" & i).Value And mnom = ThisWorkbook.Sheets("Feuil1").Range("F" & i).Value And mprenom = ThisWorkbook.Sheets("Feuil1").Range("G" & i).Value Then
ThisWorkbook.Sheets("Feuil1").Range("E" & i).Value = ""
ThisWorkbook.Sheets("Feuil1").Range("F" & i).Value = ""
ThisWorkbook.Sheets("Feuil1").Range("G" & i).Value = ""
ThisWorkbook.Sheets("Feuil1").Range("H" & i).Value = ""
ThisWorkbook.Sheets("Feuil1").Range("I" & i).Value = ""
ThisWorkbook.Sheets("Feuil1").Range("J" & i).Value = ""
Exit For
End If
Next
End Sub