Carlos Ruano
Member
Hi, I have a workbook that I create for Project Managers on a monthly basis. There are several sheets in it, and I am trying to find a way to consolidate it a bit if possible. One of my thoughts is to use only one sheet for three pivot tables. I do not want to have the pivot tables one below the other on the same sheet. What I want instead (if possible), is to have one sheet with a pivot table that can be changed with the click of a button.
In other words, right now I have three sheets with pivot tables. Those sheets are called, "Hrs by Dept & Div per Month", "Hrs by Activity per Month", and "Activity by Employee by Month". What I want instead, is one sheet called "Pivot Tables", and three buttons at the top called, "Hrs by Dept & Div per Month", "Hrs by Activity per Month", and "Activity by Employee by Month". When I click on any of the buttons at the top, the pivot table will transform into the pivot table by that name. I hope this is clear!
Is what I want to achieve possible? I have attached a sample file
If VBA is the only solution, then I am fine with that, but I am hoping to see solutions that do not use VBA, too!
Thanks!
Carlos
In other words, right now I have three sheets with pivot tables. Those sheets are called, "Hrs by Dept & Div per Month", "Hrs by Activity per Month", and "Activity by Employee by Month". What I want instead, is one sheet called "Pivot Tables", and three buttons at the top called, "Hrs by Dept & Div per Month", "Hrs by Activity per Month", and "Activity by Employee by Month". When I click on any of the buttons at the top, the pivot table will transform into the pivot table by that name. I hope this is clear!
Is what I want to achieve possible? I have attached a sample file
If VBA is the only solution, then I am fine with that, but I am hoping to see solutions that do not use VBA, too!
Thanks!
Carlos