Hi there,
I need a vba that will filter cell only for its current month - i know the filter option, but i cannot use it every month since the month will change and want to make this more automated for someone who is not good with excel:
'Filtering Newly Created based on current month data
Sheets("SSS Rpt").Select
Range("$A$9:$KK$10000").AutoFilter Field:=80, Operator:= _
xlFilterValues, Criteria2:=Array(1, "6/30/2014")
so instead of 6/30/2014 - how do I set this filter for the current month only, because next month i'd have dates for July, and etc.
Also, is it possible to filter for a month before the current month, so onstead of filtering it for the current month, i want to filter it for the previous month?
I need a vba that will filter cell only for its current month - i know the filter option, but i cannot use it every month since the month will change and want to make this more automated for someone who is not good with excel:
'Filtering Newly Created based on current month data
Sheets("SSS Rpt").Select
Range("$A$9:$KK$10000").AutoFilter Field:=80, Operator:= _
xlFilterValues, Criteria2:=Array(1, "6/30/2014")
so instead of 6/30/2014 - how do I set this filter for the current month only, because next month i'd have dates for July, and etc.
Also, is it possible to filter for a month before the current month, so onstead of filtering it for the current month, i want to filter it for the previous month?
Last edited: