Hey guys,
I'm trying to filter some data in excel (2002) i have 'company name', 'location', and 'industry sector' as my column headers but if i use the autofilter i have all the other options like top 10, custom, and then all the data listed. i dont want the user to have more than the option i select (basically just the data), now i know how to make a drop down list box and edit the options available in that but can't work it out for filtering.
im trying to make sure this makes sense, for example the drop down on the header will have the options of france, UK and germany and selecting france will show only those locations from france and give a total of displayed results at the bottom.
the problem i have is not being able to customise the autofilter drop down option and getting excel to display the count of records without including it in one of the lists and also recalculating the totals as ichange the drop down header option.
ive thought about trying this with a pivot table but although that will tell me the number in a particular location etc it won't filter the results and i'm not sure how to get both.
i want the person who receives this to just click the header 'location' (for eg) select the country they are interested in and see those results along with a number stating the total records. and then the same for the other colums
any ideas?
I'm trying to filter some data in excel (2002) i have 'company name', 'location', and 'industry sector' as my column headers but if i use the autofilter i have all the other options like top 10, custom, and then all the data listed. i dont want the user to have more than the option i select (basically just the data), now i know how to make a drop down list box and edit the options available in that but can't work it out for filtering.
im trying to make sure this makes sense, for example the drop down on the header will have the options of france, UK and germany and selecting france will show only those locations from france and give a total of displayed results at the bottom.
the problem i have is not being able to customise the autofilter drop down option and getting excel to display the count of records without including it in one of the lists and also recalculating the totals as ichange the drop down header option.
ive thought about trying this with a pivot table but although that will tell me the number in a particular location etc it won't filter the results and i'm not sure how to get both.
i want the person who receives this to just click the header 'location' (for eg) select the country they are interested in and see those results along with a number stating the total records. and then the same for the other colums
any ideas?
