Hi, I cant understand why I have no results when running the code, which I recorded.
It worked fine with Excel 2010, but is useless in Excel 2016.
Sub AdvFilt()
Range("A1:E20").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range( _
"H1:L2"), CopyToRange:=Range("H4:L100"), Unique:=False
End Sub
This is the data:
Thank you for your help!
Jorge
Edited byDeus IraeTuesday, November 5, 2019 3:50 PM
The problem was the date format in the criteria, although my system is configured with european date format, in the criteria I had to use american: <=11/30/19.