• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Excel for Operations Management Course
    • Excel for Decision Making Under Uncertainty Course
    • Excel for Finance Course
    • Excel Analysis ToolPak Course
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
    • Password Reset
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

Need Help|VBA & Macros|Excel Forum|My Online Training Hub

You are here: Home / Need Help|VBA & Macros|Excel Forum|My Online Training Hub
Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search|Last Search Results
Search
Forum Scope




Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_CrumbsHome HomeExcel ForumVBA & MacrosNeed Help
sp_PrintTopic sp_TopicIcon
Need Help
Avatar
Srikanth Viswanathan

New Member
Members
Level 0
Forum Posts: 2
Member Since:
March 3, 2018
sp_UserOfflineSmall Offline
1
March 3, 2018 - 12:30 am
sp_Permalink sp_Print

Hi All,

To be frank I'm a newbie when it comes to VBA coding.

I need help in terms of SYNCING slicers from a same data source but the I have 4 slicers to be in sync. Please look at the below example.

What I'm trying to do is to create a dashboard using slicers. If I'm Selecting Issue as "A", only Sub Type of "A" i.e., "1,2,3" should be filtered in slicer2 that is Issue Sub Type. After selecting Sub Type from the filtered items displayed in the slicer, respective Resolution of the Issue Sub Type should be displayed as a filtered item in slicer3. Now the tricky part is Resolution Sub Type as I need only the relevant Resolution sub type only to be displayed drilled down to the resolution, issue sub type and issue.

 used the following code found online to the get the table sync, but I was able to Sync only 3 slicers by actually creating a slave slicer.

Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)
Dim wb As Workbook
Dim scShort As SlicerCache
Dim scLong As SlicerCache
Dim siShort As SlicerItem
Dim siLong As SlicerItem

On Error GoTo errHandler
Application.ScreenUpdating = False
Application.EnableEvents = False

Set wb = ThisWorkbook
Set scShort = wb.SlicerCaches("Slicer_Resolution")
Set scLong = wb.SlicerCaches("Slicer_Resolution1")

scLong.ClearManualFilter

For Each siLong In scLong.VisibleSlicerItems
    Set siLong = scLong.SlicerItems(siLong.Name)
    Set siShort = Nothing
    On Error Resume Next
    Set siShort = scShort.SlicerItems(siLong.Name)
    On Error GoTo errHandler
    If Not siShort Is Nothing Then
        If siShort.Selected = True Then
            siLong.Selected = True
        ElseIf siShort.Selected = False Then
            siLong.Selected = False
        End If
    Else
        siLong.Selected = False
    End If
Next siLong

exitHandler:
    Application.ScreenUpdating = True
    Application.EnableEvents = True
    Exit Sub

errHandler:
    MsgBox "Could not update pivot table"
    Resume exitHandler
End Sub

 

PLEASE HELP ME WITH A SOLUTION AS I'M DOING THIS AS A SMALL PROJECT TO HELP OUT MY TRAINING TEAM.

Issue Issue Sub Type Resolution Resolution Sub Type
a 1 AB 123
a 1 AB 124
a 1 AC 147
a 1 AC 148
a 1 AD 155
a 1 AD 156
a 1 AE 144
a 1 AE 145
a 2 AC 123
a 2 AC 124
a 2 AC 147
a 2 AC 148
a 2 AD 155
a 2 AD 156
a 2 AE 144
a 2 AE 145
a 3 AB 123
a 3 AB 124
a 3 AC 147
a 3 AC 148
a 3 AD 155
a 3 AD 156
a 3 AD 144
a 3 AD 145
b 4 BB 222
b 4 BB 223
b 4 BB 224
b 4 BB 225
b 4 BB 226
b 4 BB 227
b 4 BB 228
b 4 BB 229
b 5 BC 321
b 5 BC 322
b 5 BC 323
b 5 BC 324
b 5 BC 325
b 5 BC 326
b 5 BC 327
b 5 BC 328
b 6 BD 421
b 6 BD 422
b 6 BD 423
b 6 BD 424
b 6 BD 425
b 6 BD 426
b 6 BD 427
b 6 BD 428
Avatar
Srikanth Viswanathan

New Member
Members
Level 0
Forum Posts: 2
Member Since:
March 3, 2018
sp_UserOfflineSmall Offline
2
March 3, 2018 - 12:31 am
sp_Permalink sp_Print

Please respond back to me in srikanthv90@gmail.com

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Velouria, Ben Hughes, Dario Serrati, Christopher Anderson, dectator mang
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 870
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
A.Maurizio: 202
Jessica Stewart: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
yashal minahil
Oluwadamilola Ogun
Yannik H
dectator mang
Francis Drouillard
Orlando Inocente
Jovitha Clemence
Maloxat Axmatovna
Ricardo Freitas
Marko Meglic
Forum Stats:
Groups: 3
Forums: 24
Topics: 6200
Posts: 27182

 

Member Stats:
Guest Posters: 49
Members: 31861
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —sp_Information

Sidebar

Blog Categories

  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
microsoft mvp logo
trustpilot excellent rating
Secured by Sucuri Badge
MyOnlineTrainingHub on YouTube Mynda Treacy on Linked In Mynda Treacy on Instagram Mynda Treacy on Twitter Mynda Treacy on Pinterest MyOnlineTrainingHub on Facebook
 

Company

  • About My Online Training Hub
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Support

  • Contact
  • Forum
  • Helpdesk - For Technical Issues

Copyright © 2023 · My Online Training Hub · All Rights Reserved. Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.