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