Dec 14 2018 01:47 PM
Hello,
I have set up an advanced filter with a macro and slicers. The slicers allow choosing options under headers, then the macro is run to filter the data. So if a member selects Principal in the slicer, runs the macro, the data filters to Principal.
My problem is, if a member selects Superintendent, the macro runs and pulls both Superintendent and Superintendent Secretary. If I filter to Superintendent in the table, it only filters Superintendent.
Please assist. I can add my macro and some other details if needed.
Jun 10 2022 10:57 AM
@AaronDoddsWould you please mind sharing it with me so I can get an idea what you are referring to? I would like just to know how to do a simple drop down based on categorical headers from the master data table. See downloads my previous uploads of my "Randomized Work." Thank you.!!!
Best,
Scott