Posted by Chris on December 07, 2001 4:38 PM
I do test score analysis for a school district (among other things). I have developed a test report using AutoFilter and the Subtotal function that allows the teachers and administrators to study how various groups of students are doing on the standardized state test. I have the report on one worksheet and the student data in another.
I need to find a way to have a cell (or cells) on the report page show which AutoFilter colums are active and which values of each autofilter are selected without user intervention. For instance, if the user had AutoFilters active for Gender (Male), Grade (3), and Ethnicity (Amerindian), the report worksheet would list "Male, 3, Amerindian".
I'm not sure that this is possible, but figured that this is the place to find out for sure.
Thanks for any assistance you can provide.