Excel Filter table on value of cell outside of table


I have a worksheet with several tables on it. I want the tables to filter automatically when there is a value in cell A2. If the cell is blank then show the tables unfiltered.

I have read various documents on the advanced filtering  but have not got this to  work.

Any direction would be appreciate.

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ken ButtersCommented:
This filters 2 tables.

Note that I stacked the tables vertically, because the autofilter hits the entire row, making side by side tables messy to say the least.

Look in Sheet1 for the code.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ckelsoeAuthor Commented:
That works!! I did figure out that side by side tables did not work out well for obvious reasons. However stacked works very well to see the data across the various tables nicely. Sometimes I overthink the obvious.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.