Drilldown Pivot Table - details to appear on the same tab

[gina12345]

Hi,

I have 2 pivot tables on the one tab, called "Other VAT".
When I double-click a cell within the first pivot, instead of opening a new tab with the data, I want the data to appear on the same tab in cell A40, which is a free cell underneath both the pivot tables.

If I then doubleclick a cell within the second pivot table, I want it to appear underneath the data from the drill down of the first pivot.

Is it possible to achieve this??

Sorry I'm really new to coding so if someone can help that would be awesome

 

[Jerry Sullivan]

Hi and Welcome to the Board,

This thread might help get you started.
MrExcel MVP Tom Urtis wrote some code to place the drill down in the same sheet as the PivotTable.

http://www.mrexcel.com/forum/showthread.php?t=289427