I have an Issues List is SharePoint that contains over 75 different categories. I would like the ability so that when I use the filter on the column title and select a particular category, that then when I click Export to Excel it only exports the issues for that particular category - is this possible?
I've thought about creating different views for each category, which seems to work but it's very time consuming and not very flexible if new categories are added.
Any ideas? Thanks guys