FlameRetired,

I appreciate the catch! I updated the original example to reflect what I actually meant.

Olly,

I appreciate the coding help. I entered the code into the worksheet module for Sheet 1, but unfortunately it doesn't seem to be working on my end. There are no results on Sheet1 when G2 and H2 change, and Sheet2 seems to clear it's filter to show no results.

Thank you both for the feedback.