make a pivot out of a selection of pivot
 

Hello smart Excel guys,

does something like this exist????

first step is clear!

1) creating a pivot table

second step is clear as well!

2) selecting data-cells within the pivot table

now it becomes more difficult

3) I wonna have the same pivot table (format, attributes, everythin) o

another sheet but with the datas I have selected just ;-)

Automatically of course by pressing a button

WOW that would be cool!!! true???

I guess I have to make it by my own but first I wanted to check
whether it is exist or not!!!

cheers..

--
filipu
-----------------------------------------------------------------------
filipus's Profile: http://www.msusenet.com/member.php?userid=125
View this thread: http://www.msusenet.com/t-187043290

make a pivot out of a selection of pivot
 

Not with a single button, but

you can copy and paste.

--
Regards,
Tom Ogilvy


"filipus" wrote in message
...

Hello smart Excel guys,

does something like this exist????

first step is clear!

1) creating a pivot table

second step is clear as well!

2) selecting data-cells within the pivot table

now it becomes more difficult

3) I wonna have the same pivot table (format, attributes, everythin) on

another sheet but with the datas I have selected just ;-)

Automatically of course by pressing a button

WOW that would be cool!!! true???

I guess I have to make it by my own but first I wanted to check
whether it is exist or not!!!

cheers...


--
filipus
------------------------------------------------------------------------
filipus's Profile: http://www.msusenet.com/member.php?userid=1258
View this thread: http://www.msusenet.com/t-1870432902

make a pivot out of a selection of pivot
 

I have something different in mind!

After selecting the cells I create kind of cache-table or bette
cache-sheet
which i use as a xlDatabase for building the new pivot table. maybe yo
now
a better way. copy and paste is not the solution defenetly becaus
otherwise
I wouldn't be interested using excel VBA programming at all...

Maybe I can write the cache-table (selection from the pivot table) i
an array
instead of tmp-sheet? would be more elegant I guess!

I need your advise!

cheers,

filipu

--
filipu
-----------------------------------------------------------------------
filipus's Profile: http://www.msusenet.com/member.php?userid=125
View this thread: http://www.msusenet.com/t-187043290

make a pivot out of a selection of pivot
 

copy and paste would be the first step to creating you cache-sheet, using a
macro of course.

However, anything that would make any functional sense (my impression) could
probably be accomplished just be further filtering down the pivot table you
already have or making a copy if it and filtering down the copy.

--
Regards,
Tom Ogilvy



"filipus" wrote in message
...

I have something different in mind!

After selecting the cells I create kind of cache-table or better
cache-sheet
which i use as a xlDatabase for building the new pivot table. maybe you
now
a better way. copy and paste is not the solution defenetly because
otherwise
I wouldn't be interested using excel VBA programming at all...

Maybe I can write the cache-table (selection from the pivot table) in
an array
instead of tmp-sheet? would be more elegant I guess!

I need your advise!

cheers,

filipus


--
filipus
------------------------------------------------------------------------
filipus's Profile: http://www.msusenet.com/member.php?userid=1258
View this thread: http://www.msusenet.com/t-1870432902