Worksheets("pour recherche").Range("A2:D500").Clear
Worksheets("pour recherche").Outline.ShowLevels RowLevels:=5
Worksheets("Rechercher Client").Range("AV2:AX100").Select
Selection.Copy
Sheets("pour recherche").Select
Range("A2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=True, Transpose:=False
Columns("C:C").Select
Application.CutCopyMode = False
Selection.NumberFormat = "d/m/yyyy"
Sheets("pour recherche").Range("A2").Select
ActiveWorkbook.Worksheets("pour recherche").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("pour recherche").Sort.SortFields.Add Key:=Range("C:C") _
, SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
ActiveWorkbook.Worksheets("pour recherche").Sort.SortFields.Add Key:=Range("B:B") _
, SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
With ActiveWorkbook.Worksheets("pour recherche").Sort
.SetRange Range("A2:C100")
.Header = xlGuess
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
Selection.Subtotal GroupBy:=3, Function:=xlSum, TotalList:=Array(2), _
Replace:=True, PageBreaks:=False, SummaryBelowData:=True
Selection.Subtotal GroupBy:=2, Function:=xlSum, TotalList:=Array(1), _
Replace:=False, PageBreaks:=False, SummaryBelowData:=True
ActiveSheet.Outline.ShowLevels RowLevels:=4
Dim tabl As Range
Set tabl = Sheets("pour recherche").Range("A2:C110")
derligne1 = Sheets("pour recherche").Range("B500").End(xlUp).Row
derligne2 = Sheets("pour recherche").Range("C500").End(xlUp).Row
Sheets("pour recherche").Rows(derligne1).Clear
Sheets("pour recherche").Rows(derligne2).Clear
For Each macellule In tabl
If macellule.Value = "" Then
macellule.Clear
End If
Next
derligne3 = Sheets("pour recherche").Range("C500").End(xlUp).Row
Set resultat = Sheets("pour recherche").Range("A2:C" & derligne3).SpecialCells(xlVisible)
resultat.Copy Destination:=Sheets("Rechercher Client").Range("W9")