Hi, The below code for Advanced filter doesnt work for me, it extracts only the header data from table. The link from where the code is taken is given below. Any help please
http://chandoo.org/wp/2012/11/27/extract-subset-of-data/
http://chandoo.org/wp/2012/11/27/extract-subset-of-data/
Code:
Sub FilterExtract()
Sheets("Filter").Select
Range("A6").Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Clear
Sheets("RawData").Range("Table1[#All]").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:= _
Sheets("RawData").Range("J1:L2"), CopyToRange:=Sheets("Filter").Range("A6"), Unique:=True
Columns.AutoFit
Sheets("Filter").Range("A6").Select
End Sub