Using Autofilter to select a subset of Records in Excel

[noboffinme]

Hi Forum,

I have a datasource that is formatted as a Table in another folder.
I have been copying the whole file to my main Workbook but now I want to select only certain records.

An excerpt of the code is below and I've been trying to add the Field Number '19' and the Term 'Yes' to Filter that Column by in the dataset using 'Autofilter'.

Sorry it's not complete code, I hope this is enough to explain how i can filter a source using Autofilter?

Thanks

Please Login or Register  to view this content.

[noboffinme]

I found the answer!
The Line should read - .ListObjects(worksheetMap(i, 4)).Range.AutoFilter Field:=19, Criteria1:="Yes"
This applies a Filter onto Column 19 and Filters to the Value of 'Yes'.
Hope this helps someone else.