@gbaker

Looking at your wbk I noticed that on the first sheet the date to be searched is placed in a merged cell.
Although it looks nice, if you have to work with it it could and will get you in trouble. So, except for purely cosmetic purposes, avoid using merged cells. Youcan replace then with the horizontal format " Center across selection" which does not have these drawbacks.

I'm also wondering why you do not simply use a filter on the date in you second sheet. Hit AltD+F+F and you can filter any day you want, or by sponsor, or whatever.

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post