Here it goes,
Can you double click on a pivot table and instead of it pulling out the
informatoin and putting it on a whole new worksheet have the data go to a
specific worksheet say between a1:d1 or a dynamic range?
--
Thank you,

Jennifer

I don't think you can change this behavior.

Jennifer wrote:

Here it goes,
Can you double click on a pivot table and instead of it pulling out the
informatoin and putting it on a whole new worksheet have the data go to a
specific worksheet say between a1:d1 or a dynamic range?
--
Thank you,

Jennifer

--

Dave Peterson

One way of doing this is as follows:

The deault behaviour response to a double-click on a pivot item is to creae
a new worksheet that lists the detai behind the item clicked.

If you want to change this default behaiour then enter code into the
newSheet event of the wokbook object. For exaple you could cop the date to
some otyher location and tehn delete the additional sheet that was created
whne you double-clicked on the pivot


"Jennifer" wrote:

Here it goes,
Can you double click on a pivot table and instead of it pulling out the
informatoin and putting it on a whole new worksheet have the data go to a
specific worksheet say between a1:d1 or a dynamic range?
--
Thank you,

Jennifer

Interesting! Thanks i'll try.
--
Thank you,

Jennifer


"DomThePom" wrote:

One way of doing this is as follows:

The deault behaviour response to a double-click on a pivot item is to creae
a new worksheet that lists the detai behind the item clicked.

If you want to change this default behaiour then enter code into the
newSheet event of the wokbook object. For exaple you could cop the date to
some otyher location and tehn delete the additional sheet that was created
whne you double-clicked on the pivot


"Jennifer" wrote:

Here it goes,
Can you double click on a pivot table and instead of it pulling out the
informatoin and putting it on a whole new worksheet have the data go to a
specific worksheet say between a1:d1 or a dynamic range?
--
Thank you,

Jennifer