Hi all,
Not sure if this is possible or not, but here goes.
You know that if you double click on a cell within a pivot table, it will create a new tab and show you the detail behind.
Is there a way that I could somehow link a cell in a second tab to a cell within the pivot table, so that when you double click on the cell it will act in the same manner.
Example: Have three tabs, tab A,B,C. Tab A in is the info tab for the pivot table, Tab B is the actual pivot table. Tab C is a report. I want to be able to link a cell within the report so that if you double click the cell, it will act as if you double clicked the cell it is linked to in the pivot table, and a new tab will be created which will show the data that makes up that total.
If anyone has any ideas on how to you could double click a number within report and get the data that makes up the total, it would be greatly appreciated
Thank You,
Dolphn22
Not sure if this is possible or not, but here goes.
You know that if you double click on a cell within a pivot table, it will create a new tab and show you the detail behind.
Is there a way that I could somehow link a cell in a second tab to a cell within the pivot table, so that when you double click on the cell it will act in the same manner.
Example: Have three tabs, tab A,B,C. Tab A in is the info tab for the pivot table, Tab B is the actual pivot table. Tab C is a report. I want to be able to link a cell within the report so that if you double click the cell, it will act as if you double clicked the cell it is linked to in the pivot table, and a new tab will be created which will show the data that makes up that total.
If anyone has any ideas on how to you could double click a number within report and get the data that makes up the total, it would be greatly appreciated
Thank You,
Dolphn22
