Using variables with pivot tables

L

Lorraine G

I have a pivot table which I would like to control from a navigation sheet
i.e. I'd like to be able to change the values in the pivot using variables.
Is this possible?
 
L

Lorraine G

Thanks for this, Roger. I think the MultiPagesChange code will work, but I
have two issues.

1. I am working with several pivots in different tabs and I need all of
them to be updated. I've tried playing around with the code to adapt it to
my situation, but I'm not too clued up with coding (only did Lotuscript many
moons ago), so any chance of some help to get me on the right track.
2. I not only need to change the results of the page, but would also like
to change the results where the same field is in a row in one of the other
pivots. Do you think this is possible?
 
Top