Sub Tri_export()
Dim Heudeb As Date
Dim heufin As Date
Datdeb = Range("O1")
Datfin = Range("S1")
Heudeb = Range("Q1")
heufin = Range("U1")
Derlig = Range("A" & Rows.Count).End(xlUp).Row
Derlig1 = Range("A" & Rows.Count).End(xlUp).Row
With Sheets("Condi")
'---------------------------------------------------- Pour les dates
.Range("A1:M" & Derlig).AutoFilter Field:=13, _
Criteria1:=">=" & Format(Datdeb, "mm/dd/yyyy"), Operator:=xlAnd, _
Criteria2:="<=" & Format(Datfin, "mm/dd/yyyy")
'---------------------------------------------------- Pour les heures
.Range("A1:M" & Derlig).AutoFilter Field:=12, _
Criteria1:=">=" & Format(Heudeb, "hh:mm:ss"), Operator:=xlAnd, _
Criteria2:="<=" & Format(heufin, "hh:mm:ss")
End With
xNbrLig = Range("A1:A" & Derlig).SpecialCells(xlCellTypeVisible).Count
If xNbrLig > 1 Then
Sheets("Condi").Range("A2:M" & Derlig1).SpecialCells(xlVisible).Copy Sheets("Bilan").Range("A4")
MsgBox "Données copiées", vbInformation, "COPIE EFFECTUEE"
ActiveSheet.Range("$A$1:$M$33").AutoFilter Field:=13
ActiveSheet.Range("$A$1:$M$33").AutoFilter Field:=12
Else
MsgBox "Aucune donnée ne correspond aux dates et heures choisies", vbCritical, "RIEN"
ActiveSheet.Range("$A$1:$M$33").AutoFilter Field:=13
ActiveSheet.Range("$A$1:$M$33").AutoFilter Field:=12
End If
End Sub