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