Pivot Table Reports
 

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

Pivot Table Reports
 

Hi Rich

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


--
Regards

Roger Govier


"Rich Mogy" wrote in message
. ..
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

Pivot Table Reports
 

Excellent -- thank you.
"Roger Govier" wrote in message
...
Hi Rich

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


--
Regards

Roger Govier


"Rich Mogy" wrote in message
. ..
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