Evaluate and Filter Part 2

This post is a follow up from the blog post earlier in the month on Filtering without a filter. It is an alternative to the autofilter method I have outlined extensively. The post focuses on filtering out more than one criteria and putting the results in a fresh sheet. To do so we use the evaluate method. This is relatively complex, however if we break down what needs to change we can significantly simplify the process.

Tags Excel, VBA, Evaluate, FIlter, autofilter, alternative