Filtering Filtered Data
 

In Excel 2007, my worksheet data comes from a SQL query, so the data in each
column is filtered after the query runs. I would like to further filter the
data by year. I know I can choose my year from the drop-down list in the
Year column, but is there any way I can say I want the data for the year I've
entered in K1? (That value is 2007 now but it will vary.)

Mary Fetsch