This is a question I posted (I think incorrectly) into the Excel general
questions and I thought it might get better response here. It relates to the
need to have a drop down list, and depending on what you select from the
list, filtering the data page accordingly.
Any help would be very gratefully appreciated.

Regards
Gai

---
Yes, I have auto filtering on, but I also need to display the filtered
"month/year" (and now) the "area" filtered on at the top of the summary page.
Instead of the person using the database having to filter the data on the
first page and then change the headings on the summary sheet, I would like
them to either select the correct "month/year" and "area" on the summary
page and the appropriate filtering happen automatically on the data page, OR,
filter on the data page and having the heading appear in the summary page
automatically. The totals calculate on the filtered information.

--
Gai


"Jim Rech" wrote:

Click to show or hide original message or reply text.


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