How to use AND, OR and Formulas with VBA Advanced Filter

👉 Ready to master VBA?
- Check out my full courses: courses.excelmacromastery.com/
- Subscribe to the channel here: bit.ly/36hpTCY
- FREE CHEAT SHEET: Get the free cheat sheet on VBA arrays here: bit.ly/2MXsnz9
(Note: If the download page doesn't work then make sure to turn off any popup blockers)

In a previous video, I show that Advanced Filter is the fastest and most efficient way to copy and filter data using Excel VBA.

In this video, I show you how to unlock the power of the Advanced Filter using AND and OR in the criteria.

We also look at the little-known method of using an Excel formula in the criteria.
Quick Guide to Advanced Filter here: (excelmacromastery.com/vba-advanced-filter/#VBA_…)

Shortcut Keys:
Alt + F11: Switch between Excel and the VBA Editor.
Ctrl + R: View the Project Properties Window.
Ctrl + Shift + 8(or Ctrl + *): Get the current region on a worksheet.
F5: Run the code from the current sub.
F9(or click left margin): Add a breakpoint to pause the code.
Tab: To move lines of code to the right(Indent)
Shift + Tab: To move lines of code to the left(Outdent).

Table of Contents:

00:00 - Introduction
01:06 - Using AND criteria
01:47 - Using OR Criteria
02:46 - Using Formulas in Criteria
05:03 - Using Wildcards