| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I link pivot tables on Page Filter? (NOT VBA LITERATE)
Hello,
I know it's possible thru Codes to link mulitple pivot tables together so you only need to change a page filter in one pivot & the rest will follow suit (all on same sheet, 1st pivot starts in a1,specific page filter is in a3, next pivot starts in g1/g3, m1/m3, etc). Is there a way to do this without going thru VBA or macros? Or can someone direct me to a good training tool? I've tried adjusting other codes I've found on other boards, but my lack of experience is making it impossible to figure out. :) Does anyone have any ideas? Thank you for you time & help! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I link pivot tables on Page Filter? (NOT VBA LITERATE)
It is VBA or nothing... If you want some help with the VBA we could do that
for you... -- HTH... Jim Thomlinson "WJB" wrote: Hello, I know it's possible thru Codes to link mulitple pivot tables together so you only need to change a page filter in one pivot & the rest will follow suit (all on same sheet, 1st pivot starts in a1,specific page filter is in a3, next pivot starts in g1/g3, m1/m3, etc). Is there a way to do this without going thru VBA or macros? Or can someone direct me to a good training tool? I've tried adjusting other codes I've found on other boards, but my lack of experience is making it impossible to figure out. :) Does anyone have any ideas? Thank you for you time & help! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I link pivot tables on Page Filter? (NOT VBA LITERATE)
If you wouldn't mind trying to walk a complete novice thru it, I'd love to
learn it! :) Thanks! "Jim Thomlinson" wrote: It is VBA or nothing... If you want some help with the VBA we could do that for you... -- HTH... Jim Thomlinson "WJB" wrote: Hello, I know it's possible thru Codes to link mulitple pivot tables together so you only need to change a page filter in one pivot & the rest will follow suit (all on same sheet, 1st pivot starts in a1,specific page filter is in a3, next pivot starts in g1/g3, m1/m3, etc). Is there a way to do this without going thru VBA or macros? Or can someone direct me to a good training tool? I've tried adjusting other codes I've found on other boards, but my lack of experience is making it impossible to figure out. :) Does anyone have any ideas? Thank you for you time & help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pivot tables value filter | Excel Discussion (Misc queries) | |||
| Update linked pivot tables when page changes in main pivot | Excel Discussion (Misc queries) | |||
| can i link pivot tables | Excel Worksheet Functions | |||
| Link Pivot Tables | Excel Discussion (Misc queries) | |||
| Link "page-by" drop-down in two pivot tables | Excel Worksheet Functions | |||
Linear Mode
