Vba to filter for multiple criteria in one column

[ScotlandsNeo]

Hi all,

I have a workbook that I need to filter whereby the focus is vba to auto filter column F for a list of names of people. This list of names is stored in another workbook in column A:A. This is to save me manually filtering and going through a large list of names to pick out only 15-20 people.

Thanks,

 

[footoo]

https://www.mrexcel.com/forum/excel...column-without-using-drop-down-filtering.html