5.9K views · 76 reactions | Advance Filter with Macro #macro #excelmacro #Excel #microsoftexcel #Microsoft #microsoftexceltutorial #exceltutorial #exceltricks | Technical Skill | Facebook

New video: Learn how to create macro buttons for Excel filters. Filters are probably one of the tools we use the most in Excel. It can be a time consuming task to apply filters using the filter drop-down menus. Especially when applying filters to multiple columns, or if you apply the same filters to the same reports every day or week. In this week's post and video I explain how to use the macro recorder to create a macro that filters multiple columns, and then create a button for it on the sheet