Thanks for the reply and info. It seems like VBA is the best option for my needs.

I suppose I could place my filter in a separate sheet and link it back to the original data. That would solve my problem of having two massive tables on the same sheet, but it feels a little over the top for what I want to do. I might try it anyway if I have time.

Thanks again.