Slicers

[MDLash]

Can slicer selections be used as criteria for getpivotdata formulas? I am trying to present a report that looks cleaner than a filtered pivot table typically does. Any suggestions? Thanks!

 

[rohith554]

yes there is a way. But depends on how you want to use it!

 

[MDLash]

yes there is a way. But depends on how you want to use it!

I found the option to "Assign Macro" to the slicer, however my slicer has three buttons and I would like each button to display a different sort of the data. Unfortunately, I can only assign one macro to a slicer "box". Thoughts?

 

[rohith554]

No i don't think there is a way to assign the macro to different items in the slicer as slicer is a object put together and you will not be allowed to assign macro to different items in the slicer.

if you want to assign the macro to the buttons you can twist it by writing a macro in the below mentioned code, where the macro runs every time when there is a change in the cell value.

Private Sub Worksheet_Change(ByVal Target As Range)

Your Code

End Sub

Hope this works!