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.