Pivot Table Reports

[Rich Mogy]

Hi All,
I have created a pivot table and have put various locations in the "Page"
area. I would now like to print a report for each location without having
to manually change the location.

How would I code my macro (VBA) to accomplish this. I suspect it would use
a
"for each" loop, but not sure what to code.

Any help, as always, is appreciated.

Rich Mogy

 

[Roger Govier]

Hi Rich

Debra Dalgleish has some code to do this on her site at
http://www.contextures.com/xlPivot09.html

 

[Rich Mogy]

Excellent -- thank you.

Hi Rich

Debra Dalgleish has some code to do this on her site at
http://www.contextures.com/xlPivot09.html