LinkBack URL
About LinkBacks
Hi all,
is there a way to filter various pivot data ( from different data sources) using one slicer with VBA.
attached file for your reference.
thanks and regards,
Hudson
Hi all,
is there a way to filter various pivot data ( from different data sources) using one slicer with VBA.
attached file for your reference.
thanks and regards,
Hudson
the obvious solution here is to merge the tables, then no "tricks" with slicers and multiple sources are needed
Hi Roel,
I did not get you and I cannot merge the data .. and the data in different years has different columns and fields but the common field is " Name of the analyst ".
see attached solution
essentially use one PRIMARY slicer and duplicate to other two slicers of which you can HIDE
i grouped slicer 2 and 3 for easy hiding
Press ALT+F10 to see this
click the eye icon to hide/unhide
your primary slicer must have all the row labels though or else it will be chopped off
ie you cant use 2016 as primary as Mefi Barrera doesnt exist
Primary code can be found under THISWORKBOOK module
**Not my original code but the URL from where i found this is now defunct so i cannot acknowledge them
Please Login or Register to view this content.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
It really worked well thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks