Select a cell in the pivot table
ON the Pivot toolbar, choose PivotTableShow Pages

Emom wrote:
I have an Excel question that I hope you can help me with. I know in the past
I have seen this done, but can't remember how to do it. When I create a
pivot table and have all the info listed there, how do I get that list to be
on individual sheets? For example, I have a list of VP's with all their cost
centers. I thought there was a way to get all the VP's to be listed on
separate sheets without having to copy the sheets and selecting which VP for
each sheet


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html