Filters
 

I have a database list with a number of columns, I have a filter on the
header row. I would like to change the filter automatically without having
to press the drop down arrow based on the contents of a cell.

So every time a cell changes to a different value, the database list will be
filtered to be reflective of the new text in the cell. This way the database
is always essentially being filtered.

Thank you