• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

code for Slicer

V

Veeru106

Member
Hi,

i have one file where i am trying to make a dashboard..I am using slicer from Pivot and then i have created 2 seperate sheets.Sample file attached...Now sheet is Single VIew and another is Compariosn View....SIngle view sheet will show data for single element if we select from slicer let's say i have selected 2018-Actuals, where as comparison view sheet will show 2 elements data like if i select 2018-Actuals and 2017-Actuals and so on)what i need is a code which automatically lead me to single view sheet if i select 1 element from Month slicer and lead me to comparison view sheet if i select multiple elements from month slicer....do we have something like this??? Thanks for looking at it
 

Attachments

  • Book1.xlsx
    30 KB · Views: 2
Would this do?
No idea on how to use slicers selections in vba, but applied a workaround with a second pivot table that shares the same slicer. Count the arguments in that pivot and use that counter in a small vba code.
It's amateur DYI-stuff... For something sophisticated, wait for others.
 

Attachments

  • SlicerSelection_SelectSheet.xlsm
    39.7 KB · Views: 8
was trying to applicate same on my sheet but have difficulty where code is not working properly....Any one else have any better idea please
 
You must log in or register to reply here.
Back
Top