Hi guys,
I am making a macro in excel for a weekly data output from an excel file.
i already have two filters included, but the third one i would like to make is a little more tricky.
I have a column with dates and i would like to include only the next three months in the output, depending on the date when using the macro. Is this possible?
When manually filtering the column it looks like this. The date format in the column is (YYYY-MM-DD).
I am making a macro in excel for a weekly data output from an excel file.
i already have two filters included, but the third one i would like to make is a little more tricky.
Code:
[/COLOR]<code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit; line-height: 12px;">ActiveSheet.ListObjects("Table1").Range.AutoFilter Field:=12, Criteria1:= _
"=Gold", Operator:=xlOr, Criteria2:="=Silver"
ActiveSheet.ListObjects("Table1").Range.AutoFilter Field:=37, Criteria1:= _
Array("G2", "G3"), Operator:=xlFilterValues</code>[COLOR=#333333]I have a column with dates and i would like to include only the next three months in the output, depending on the date when using the macro. Is this possible?
When manually filtering the column it looks like this. The date format in the column is (YYYY-MM-DD).
Last edited by a moderator:
