Here is the code i am using:
Code
Range("A:I").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range( _
"O14:O15"), CopyToRange:=Worksheets("Report2).Range("A19"), Unique:=False
I am basically trying to advance filter data on worksheet "Custpercust" and i want to filter it to another worksheet, which is "Report2".