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!

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!

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!