itil

ITIL Reporting

excel

ITIL 4

excel

Power BI

excel

Excel Formula | Macro | Script

Remove filter using a macro in an excel report

There are 2 codes to unfilter data, the general one is to use for most of the scenarios and one specifically for a table.

macro excel macro excel

 

When I use the macro ?

For instance, if the data is filtered, I won´t be able to copy the full data except if I unfilter it first.

 

How to create the macro ?

Read How to create, edit, hide and select a macro in an excel report

 

How to create the button to associate it with the macro ?

Read How to create a button and associated it to a macro in an excel report

 

How is/are the macro(s) ?

Copy the code below and paste it into your macro. You will see my comments in green if exist so follow the help to adapt to your need.

General one:


Sub test()
On Error Resume Next
' for a specific sheet, change ActiveSheet by Worksheets("sheetname")
ActiveSheet.ShowAllData
End Sub

For a table:


Sub test()
' replace tablename by yours
' for a specific sheet, change ActiveSheet by Worksheets("sheetname")
ActiveSheet.ListObjects("tablename").AutoFilter.ShowAllData
End Sub

Interesting Topics