Advanced filter that changes as criteria range changes

[JamesonMH]

Hi folks,

Is there a way to use the Advanced Filter tool (under Sort & Filter in Excel 2013) so that my filtered values change as my criteria range changes?

For example, I currently setup my criteria range by highlighting my subset (of items I want filtered) and then my master list (aka list range) filters accordingly.

My question is...I then want to be able to change the values in the criteria range and have the master lists' filter change accordingly.

How can I do that, if at all?

Thanks,
James