Hi there,

I need some help please: is there a way to use the autofilter function to filter data based on a value present in another cell? For instance if cell $T$50 contained the number "5", could I enter an expression in the autofilter criteria which pointed to that cell. That way i could change the cell value, and change the filter parameter?

If not, is there another easy option for filtering a dataset based on a changing value please.

Thanks very much

Mark