A macro to identify the month in another column and filter the data month in the other column.

[nonono]

As what the title said, if column "I" month shows the latest month which is month "May"

Make column "H" filter out only data month with "May" only...

 

[nonono]

still need help

 

[Yongle]

Try this
- your dates may not look the same, but should still function correctly

My results:




With
- month selected in cell R1
- data in columns A:P
- Headers in row 1
- column I & H values are dates
- cell R1 value is a date

Paste code into sheet module (right-click sheet tab \ View Code \ paste code in window on right)

Sub MonthFilter()
    Dim rng As Range:       Set rng = ActiveSheet.Range("A:P")
    Dim MyCriteria:         MyCriteria = GetDatesInPeriodConst(month(Range("R1")))
    On Error Resume Next
    rng.Parent.ShowAllData
    rng.AutoFilter field:=9, Criteria1:=MyCriteria, Operator:=xlFilterDynamic
    rng.AutoFilter field:=8, Criteria1:=MyCriteria, Operator:=xlFilterDynamic
End Sub

Function GetDatesInPeriodConst(month As Long)
    GetDatesInPeriodConst = 20 + month
End Function