Pivort table
 

Hi How would I get 2 pivort tables in 1 worksheet? Any help.

Thanks,
--
kaushi

Pivort table
 

Copy Paste works with Pivot Tables also


--
Pecoflyer

Cheers
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=33024

Pivort table
 

Thanks
--
kaushi


"Pecoflyer" wrote:


Copy Paste works with Pivot Tables also


--
Pecoflyer

Cheers
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=33024

Pivort table
 

Hi,

1. You can copy and paste the pivot table, but then it is running from the
same cache' which may limit your grouping options and other things.
2. You can select the raw data and proceed as you did to create the first
pivot table, when asked if you want to save memory by using the same cache'
you can say yes or no depending on your needs. If you say no, both pivot
table are independent of each other.

If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Kaushi" wrote:

Hi How would I get 2 pivort tables in 1 worksheet? Any help.

Thanks,
--
kaushi