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