Option Explicit
Sub SpecialAdavancedFilterLoop()
Dim PlageSource As Range
Dim PlageCriteria As Range
Dim PlageCible As Range
Dim i As Byte
Set PlageSource = Range('B1:B250')
Set PlageCriteria = Range('I1')
Set PlageCible = Range('I4')
For i = 1 To 30
PlageSource.AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=Range(PlageCriteria.Offset(0, i), PlageCriteria.Offset(1, i)), _
CopyToRange:=Range(PlageCible.Offset(0, i), PlageCriteria.Offset(48, i)), _
Unique:=True
Next
End Sub