i'm hoping this is an easy one, but wracking my brains trying to use create a simple fix.
I am trying to remove an auto-filter (across A6:O6) on a small table (not an actual table) of data, when the 'clear filter' button is clicked on a slicer. I already have the slicer filter the table so it hides rows based on the slicer selection by way of a macro as its not actually connected to the slicer. The table is just static and populated values from pivots on another sheet. The only issue is when the slicer filter is cleared the table remains filtered and so if possible I would like the clearing of the pivot slicer remove the autofilter from A6:O6.
I could just add a macro button to 'show all' or 'reset' that removes the autofilter but it would be nice to tie it in with clearing the pivot slicer.
Bookmarks