http://www.onlinepclearning.com
Excel Userform Advanced Filter with Multiple Criteria tutorial. This Video tutorial will deal with creating a multiple criteria advanced filter that run from a userform. You will be able to leave criteria blank and the filter will still work successfully.
The userform can run from any worksheet so as not to show the source data.