Copying data from Pivot table to another worksheet

[Sheri]

This is my first attempt in creating a macro and I really need help. I have a list of "Processor" in the Pivot row label field and what I need is for the macro to run new worksheets and name it using the name of processors in the list. Also it should copy the pivot data (including pivot format eg. flags) of each processor to its corresponding worksheet. In the sample provided I should have 4 new worksheets (A,B,C,D) with their data in it. The copied data will have to be just plain excel (not pivot).

Appreciate any help.

 

[jeffreyweir]

You can actually do this without a macro. Excel can automatically create separate copies of pivots - one for each item in a PivotFilter - and put them in separate tabs? It's called 'Show Report Filter Pages'

http://www.pivot-table.com/2012/10/29/create-worksheet-for-each-pivot-item/

 

[Sheri]

Thanks so much Jeffrey. You taught me something new today. I didn't know pivot can do such a thing. Excel never stops to amaze me. It did solve part of my problem. I need to also copy the pivot format though. My original pivot table has flags as part of conditional formatting. Is there a way to copy this as well to the new worksheets?

 

[jeffreyweir]

In that case you'll need some VBA code. Check out http://www.pivot-table.com/2012/10/29/create-worksheet-for-each-pivot-item/

 

[Sheri]

I opted to use the 'Show Report Filter Pages' instead of using VBA codes. I grouped the new worksheets and pasted the format from the original sheet. It works well. Thanks for your help Jeffrey.

 

[jeffreyweir]

Cool!