Sub ExtractThisWeek()
Dim rng As Range
Set rng = Worksheets("Data").Range("A1").CurrentRegion
rng.AutoFilter Field:=1, _
Operator:=xlFilterDynamic, _
Criteria1:=xlFilterThisWeek
End Sub
使用例:第1四半期(1–3 月)のデータを抽出
Sub ExtractQuarter1()
Dim tbl As Range
Set tbl = Worksheets("Data").Range("A1").CurrentRegion
tbl.AutoFilter Field:=1, _
Operator:=xlFilterDynamic, _
Criteria1:=xlFilterAllDatesInPeriodQuarter1
End Sub
使用例:平均以上の数値を抽出
Sub ExtractAboveAverage()
Dim src As Range
Set src = Worksheets("Data").Range("B1").CurrentRegion
src.AutoFilter Field:=3, _
Operator:=xlFilterDynamic, _
Criteria1:=xlFilterAboveAverage
End Sub