Automatically change a Pivot Table

[Andrew T Smith]

What i'm looking to do is to make a hyperlink from one table that when
you click on it, will automaticaly change the page fields on my pivot
table and then bring you to the pivot table based on the criteria set
in the hyperlink. Is this possible and if so PLEASE help me.

Andrew

 

[Tom Ogilvy]

in xl2000 and later, there is a followhyperlink event. The hyperlink would
flow to the pivot table. You would write the code to change the pivot table
and place it in the followhyperlink event with appropriate If / conditional
statements.

You can get sample code for altering you pivot table by turing on the macro
recorder and making the adjustment manually. Then modify it to work with
the followhyperlink event.