Actually no - I know how to do that. What I am talking about is the fact
that if you do something it brings all the VP's down to their individual
sheet (as the pivot table) and the sheet gets named by the VP.

"John Michl" wrote:

If you Pivot table is summarized by VP, you should be able to double
click on a value related to one of the VPs and Excel will create a
drill down sheet for that VP. Is that what you are talking about?

- John