Folks,
I need to filter data based on the value of H3 which contains of Month & Year, for example Jan 2014. And the data to filter consist of :
18 May 2014
7 Jan 2014
22 Jan 2014
11 Mar 2014
I just can't figure it out how to filter the data only based on Month & Year, this code below is not working.
Need you help to fix the bug.
regards
I need to filter data based on the value of H3 which contains of Month & Year, for example Jan 2014. And the data to filter consist of :
18 May 2014
7 Jan 2014
22 Jan 2014
11 Mar 2014
I just can't figure it out how to filter the data only based on Month & Year, this code below is not working.
Need you help to fix the bug.
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
Range("B16:Z17").AutoFilter
If Not Intersect(Target, Range("H3")) Is Nothing Then
Range("B16:Z16").AutoFilter Field:=7, Criteria1:=Range("H3").Value
End If
regards