hey all, I'm having some difficulty in making my pivot tables into a useful printed report - Excel does not seem to allow the user to summarize what criteria has been selected in the report.

Let me provide an example.

If I have data for sales of green, yellow, and red cards for 2005 2006 and 2007, I can make a master pivot table that has all this data. Then, if the manager of red car sales needs a report, I want to select just the red and print that. However, there's no command to pull the fact that I have selected only "red" under the cars type. This is a simplistic example of a larger problem - on a pivot table with a lot of criteria, it really diminishes the usefullness of a table if you can't automatically show what you selected in the header of the document.

I've seen this done for lists via VBA but I can't find a piece of code that will work with a pivot table. Can anyone help?