I want to double click on a Cell in a Summary Worksheet and have the Pivot Table Cell details open in a new worksheet. The cell in the Summary worksheet contains the data from a Pivot table on another sheet using GetPivotData().
When I Double click on the cell in my Summary WorkSheet, I want the details (Drill Down) of the corresponding Pivot Table cell to open in a new Worksheet.
Anyone have some thoughts on what VBA code I can call and in what event?
Bookmarks