That's called a page field.

See Debra Dalgleish for some sample code:
http://contextures.com/xlPivot09.html#Page


If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

wrote:

Hello
I am trying to print out individual reports from a pivot table where
the changing value will be in the column field (the field that can be
found at the top of the pivot table. The info for the table comes from
our accounting department and can be automatically updated, but to
simplify the printing I would like that to be semi automatic, without
going through each name. Any ideas ?
Thanks
Stan

--

Dave Peterson