Home

Excel Slicer and Macro Drop Down

%3CLINGO-SUB%20id%3D%22lingo-sub-302172%22%20slang%3D%22en-US%22%3EExcel%20Slicer%20and%20Macro%20Drop%20Down%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-302172%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20have%20set%20up%20an%20advanced%20filter%20with%20a%20macro%20and%20slicers.%20The%20slicers%20allow%20choosing%20options%20under%20headers%2C%20then%20the%20macro%20is%20run%20to%20filter%20the%20data.%20So%20if%20a%20member%20selects%20Principal%20in%20the%20slicer%2C%20runs%20the%20macro%2C%20the%20data%20filters%20to%20Principal.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20problem%20is%2C%20if%20a%20member%20selects%20Superintendent%2C%20the%20macro%20runs%20and%20pulls%20both%20Superintendent%20and%20Superintendent%20Secretary.%20If%20I%20filter%20to%20Superintendent%20in%20the%20table%2C%20it%20only%20filters%20Superintendent.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20assist.%20I%20can%20add%20my%20macro%20and%20some%20other%20details%20if%20needed.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-302172%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
AaronDodds
Frequent Visitor

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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies