Filter criteria from another cell?

I'm doing spreadsheets with built-in filters accessible through
buttons/macros. The advanced filters use criteria fields to determine
what data to filter, i.e., a column header with a < or> and the number
in the cell beneath it. I also have than number elsewhere in the
spreadsheet with a more "user-friendly" label. Is there a way to get
the filter criteria to refer to the other cell and apply a "greater
than" or "less than" to that number? In other words, the filter
criteria would point to the value in the other cell and apply a < or >
to that value. Any ideas?
Thanks in advance.

In the criteria area, use the same heading as is on your date column.
In the cell below, use a formula to refer to the cell that contains the
date, e.g.: =">"&K2

davegb wrote:
> I'm doing spreadsheets with built-in filters accessible through
> buttons/macros. The advanced filters use criteria fields to determine
> what data to filter, i.e., a column header with a < or> and the number
> in the cell beneath it. I also have than number elsewhere in the
> spreadsheet with a more "user-friendly" label. Is there a way to get
> the filter criteria to refer to the other cell and apply a "greater
> than" or "less than" to that number? In other words, the filter
> criteria would point to the value in the other cell and apply a < or >
> to that value. Any ideas?
> Thanks in advance.
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thanks, Debra, worked great!