I set up an advanced filter for a sheet(QTD_710_NEG sheet). I can't figure out how to code the Range criteria directly into the macro instead of having to create the range Filter Criteria sheet, populate it with the criteria, and reference those cells.
Here is the code as it currently sits
Range("RANGE_QTD_710_NEG").AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:= _
Sheets("Filter_Criteria").Range("E2:F3"), Unique:=False
How can I hard code the information on the "Filter Criteria" sheet into the advanced filter instead of creating the "Filter Criteria Sheet", populating it, and then referencing it the advanced filter Range
I have attached a sample if needed.Sample.xlsx
Thanks,
Craig
Bookmarks