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
marionatdjian
Occasional Contributor

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

@marionatdjian 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