Excel VBA for Pivot Table drilldown on the same worksheet

[jsnyder57]

I have been trying to find a way to get my Pivot Table drilldown to occur on the same worksheet that the table is housed on. I have found a couple of posts by User Tom Urtis on here that relate for exactly what I am trying to do, but I am not sure where to start. I have been using excel for quite some time, but this is the first time I have ever ventured into the land of VBA. I think that the code that is referenced in forum

http://www.mrexcel.com/forum/excel-...ibly-one-visual-basic-applications-gurus.html

Can anyone please help me get started?

 

[Jerry Sullivan]

Hi and Welcome to the Board,

In a more recent thread, forum member maek documented the steps he or she used to setup Tom's code.

http://www.mrexcel.com/forum/excel-...dd-new-sheet-when-drill-down-code-active.html

That thread contains a link with a more recent version of the code from Tom.

Just ask if you get stuck.

 

[jsnyder57]

Thank you so Much for those links. It now works exactly how I want it to.