Filtering Filtered Data

M

Mary Fetsch

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top