| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Selection | Excel Discussion (Misc queries) | |||
| Pivot Tables - Row Selection | Excel Discussion (Misc queries) | |||
| pivot table selection | Excel Worksheet Functions | |||
| changing pivot selection | Excel Programming | |||
| Pivot Table - Multiple Pivot Field Selection | Excel Programming | |||
Linear Mode
