How to Automatically Group Rows based on Cell Value

Показать описание

New course Launched! I created it to show you step-by-step how to design a salary structure with regression analysis in Excel. Check out the detail here:
Scenario: You want to automatically hide content with one click
Function: Macro

Related Videos:

***Macro Code***
Private Sub Worksheet_Change(ByVal Target As Range)
ActiveSheet.Activate
If Not Application.Intersect(Range("C5"), Range(Target.Address)) Is Nothing Then
Select Case Target.Value
Case Is = "Detail by Country": ActiveSheet.Outline.ShowLevels RowLevels:=2, ColumnLevels:=2
Case Is = "Summary": ActiveSheet.Outline.ShowLevels RowLevels:=1, ColumnLevels:=1
End Select
End If
End Sub

******Follow-up Consulting Services******

******More Videos in Playlists******

#ExcelforHR#HRAnalytics#Excel#HR