VBA Advanced Filter Code and Template can be downloaded from here:
http://www.onlinepclearning.com/vbaa...
Advanced filters with AND OR operators. We will be using the Microsoft Excel Advanced filters with VBA code.
In this tutorial I will show you how to run an advanced VBA filter with both the AND and OR operators.
This will enable us to filter multilple criteria for multiple staff.
I have also added the feature to filter beween dates.
Advanced filters AND / OR and Between