A couple of weeks ago I described how you could select a cell in a table, and automatically filter the list based on that cell's value. The same feature is available in Excel 2007, using a different technique.

Using the same example as in the previous post, the East region is selected in the table [...]