G
Gai
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
:
Click to show or hide original message or reply text.
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
:
Click to show or hide original message or reply text.