cell change to trigger advance filter in excel 2007

I am trying to set up a macro to filter an inventory data set in excel so staff can reduce the number of visible items when updating a value by just changing a field in the criteria selection.
Can this be done automatically?