So i need to create a front end user friendly dashboard, where a user can select multiple divisions and have it update a pivot table, but they do not want to go into the pivot table itself. I have figured out how to name the pivots with one selection using the drop down below is the code for it. But i am thinking to have all of the divisions labeled as check boxes where they can select/mix and match.


>>>>>Sub DropDownDivision()
Application.ScreenUpdating = False

[PipelinePivot1Div].Value = [DivisionCode].Value
[PipelinePivot2Div].Value = [DivisionCode].Value
[PipelinePivot3Div].Value = [DivisionCode].Value
[PipelinePivot4Div].Value = [DivisionCode].Value
[ClientPivot1Div].Value = [DivisionCode].Value
[ClientPivot2Div].Value = [DivisionCode].Value
[RepPivot1Div].Value = [DivisionCode].Value
[RepPivot2Div].Value = [DivisionCode].Value
[RevDiv].Value = [DivisionCode].Value

Application.ScreenUpdating = True
End Sub
<<<<