pivot table to sheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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.
 
Sorry. I'm not familiar with that. I would think that if the sheet is
getting renamed, it is probably some VBA macro that is accomplishing
it.

Good luck.

- John
 
Sorry. I'm not familiar with that. I would think that if the sheet is
getting renamed, it is probably some VBA macro that is accomplishing
it.

Good luck.

- John
 
Select a cell in the pivot table
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
Click to expand...
 
Back
Top