Home

Automated filters

%3CLINGO-SUB%20id%3D%22lingo-sub-797514%22%20slang%3D%22en-US%22%3EAutomated%20filters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-797514%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20table%20with%20muliple%20columns%20all%20with%20filters.%20I%20would%20like%20to%20create%20few%20%22buttons%22%20from%20which%20you%20could%20you%20click%20on%20it%20and%20it%20would%20filtered%20each%20column%20like%20I%20decided%20(ex%3A%20column%20A%20from%20high%20to%20low%3B%20column%20B%20only%20empty%20celss%3B%20etc....)%20and%20gice%20them%20names%20like%20one%20is%20to%20see%20%22retail%20low%20sales%22%20or%20%22Eco%20top%20sales%22%20etc.%3C%2FP%3E%3CP%3EI%20never%20done%20any%20macro%20yet%2C%20is%20it%20the%20only%20way%20to%20this%20type%20of%20things%20%3F%20If%20so%20happy%20to%20have%20a%20video%20that%20explain%20steps.%3C%2FP%3E%3CP%3EThanks%20!!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-797514%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Efilters%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-797931%22%20slang%3D%22en-US%22%3ERe%3A%20Automated%20filters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-797931%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F366218%22%20target%3D%22_blank%22%3E%40marionatdjian%3C%2FA%3E%26nbsp%3Bhello%20there.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%2C%20you%20would%20need%20VBA%20for%20this.%20Best%20way%20to%20do%20so%20is%20to%20record%20a%20macro%20of%20you%20clearing%20and%20setting%20the%20filters%20to%20what%20you%20want.%20You%20can%20always%20post%20the%20code%20here%20to%20help%20get%20it%20cleaned%20up.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENote%3A%20if%20you%20need%20to%20show%20the%20Developer%20tab%20and%20it's%20not%2C%20right%20click%20anywhere%20on%20the%20ribbon%20and%20select%20%22Customize%20the%20Ribbon...%22%2C%20and%20on%20the%20right%20list%20box%20check%20the%20box%20next%20to%20%22Developer%22%20and%20hit%20OK.%20Click%20the%20Developer%20tab%20and%20%22Record%20Macro%22%20to%20begin.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHTH%3C%2FP%3E%3C%2FLINGO-BODY%3E
Deleted
Not applicable

Hi everyone,

 

I have a table with muliple columns all with filters. I would like to create few "buttons" from which you could you click on it and it would filtered each column like I decided (ex: column A from high to low; column B only empty celss; etc....) and gice them names like one is to see "retail low sales" or "Eco top sales" etc.

I never done any macro yet, is it the only way to this type of things ? If so happy to have a video that explain steps.

Thanks !!!

1 Reply

@Deleted hello there.

 

Yes, you would need VBA for this. Best way to do so is to record a macro of you clearing and setting the filters to what you want. You can always post the code here to help get it cleaned up. 

 

Note: if you need to show the Developer tab and it's not, right click anywhere on the ribbon and select "Customize the Ribbon...", and on the right list box check the box next to "Developer" and hit OK. Click the Developer tab and "Record Macro" to begin.

 

HTH

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 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