So are you using AutoFilter? Data, Filter, AutoFilter would create a
dropdown at the top of each column. Users could select the criterion for
each column as desired. The filtered results could then be copied to the
summary sheet manually.

If you want something fancier then you'd need to connect with someone with
some facility with Excel macros to automate this process.

--
Jim
"Gai" wrote in message
...
|I think I might need to use ActiveX which I currently have no knowledge on,
| but maybe I'm wrong.
|
| I have a large database which gets filtered "Month/year" and the filtered
| results feed into a summary page on the second sheet.
|
| I am not the primary user of this spreadsheet and the users for the most
| part have little excel skills or experience.
|
| Each month (or as required- ie part way through the month), the users will
| need to print a report on the summary data. The problem is to use the
summary
| page, the user must filter the first page for the month/year, then select
| from a drop down list (at this stage just a validation) the appropriate
| month. This gives them a monthly average. I now need to make it more
| complicated again by summarising by "month/year" AND "area". The chances
of
| them remembering to filter on the "area" as well as the "month/year" AND
use
| the drop down lists on the summary page is getting less likely.
|
| What I want to happen is that they select an entry from the drop down list
| (maybe a combo box?) and the first sheet will filter accordingly. Likewise
| with the "area" drop down list.
|
| Can anyone help me?
|
| --
| Gai