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

Use Data Validation to create a drop down list. Watch how. | Microsoft Excel