Automatic filter lookups

After an appropriate cell reference is made to a field from within a filter, if you double-click the cell that has been referenced in a Query Definition, then a Filter Lookup dialog box is displayed.

This enables you to select a different value from the lookup and recalculate the report to extract the modified query.

The cell must contain a valid value before it can be referenced. This feature is only for cells that contain values and not cells that reference other cells or Named Cell References.

For example, A1 contains =Sheet1B8 and B8 contains the value for Code.