J Srdarov
05-31-2007, 02:44 AM
Hello All,
First post on here.
I have spent the afternoon perusing your board and can't find what I am looking for, so have decided to post on the issue. I have been going crazy looking through vba books etc to find a similar example that I can adapt to my situation but havent been successful.
I am attempting to create a simple spreadsheet report that contains 3 seperate filters (in the form of a drop down list) at the top of the page for the following variables:
- Year
- Region
- Age Group
I have attached a small sample to this post of what I will be working with.
Since the columns that contain the data that will be filtered on will be hidden (columns E - G) I cannot use the autofilter or advanced filter options and therefore need some type of macro. The macro must be accurate in the sense that it will enable a person to make say a selection in any of the drop down filters and then the rows of data that don't correspond to the selections are then hidden. The user will then be able to make numerous changes to the filters as per their desire when analysing the data. Each filter will ideally also contain the value All which will enable them to look at say all age groups within the data range. I would also really like some sort of drop down arrow displayed to the right of each drop down list filter.
I will be working with Excel 2003.
Is anyone able to :help
Thanks
Jamey
First post on here.
I have spent the afternoon perusing your board and can't find what I am looking for, so have decided to post on the issue. I have been going crazy looking through vba books etc to find a similar example that I can adapt to my situation but havent been successful.
I am attempting to create a simple spreadsheet report that contains 3 seperate filters (in the form of a drop down list) at the top of the page for the following variables:
- Year
- Region
- Age Group
I have attached a small sample to this post of what I will be working with.
Since the columns that contain the data that will be filtered on will be hidden (columns E - G) I cannot use the autofilter or advanced filter options and therefore need some type of macro. The macro must be accurate in the sense that it will enable a person to make say a selection in any of the drop down filters and then the rows of data that don't correspond to the selections are then hidden. The user will then be able to make numerous changes to the filters as per their desire when analysing the data. Each filter will ideally also contain the value All which will enable them to look at say all age groups within the data range. I would also really like some sort of drop down arrow displayed to the right of each drop down list filter.
I will be working with Excel 2003.
Is anyone able to :help
Thanks
Jamey