VBA Advanced Filter Code and Template can be downloaded from here:
http://www.onlinepclearning.com/vba-advanced-filter-and-or-operators/
Advanced Filters And Or operators tutorial Part 2. We are using the AND OR operators.
This the video with the formulas and VBA code to run our advanced filters. Copy the formulas and VBA code from the video.