• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to create pivots in existing worksheet

A

Aashish Aggarwal

New Member
I have a base data with 10 columns and number of rows can vary (as data to be entered in these daily).
1 column is "name" and using this i have already written a code that can create new worksheets in existing workbook with unique names in that column only.

Now I want to create pivot tables to summarize the data in these existing worksheets(that are also named as column values of column "name"). How can we do this?

Conditions: If worksheet with a pivot table already exist, it should not create new worksheet (as their will be duplicates)

Please help out with this.!!
 
It would be much more efficient to just build one PivotTable based off the original data. Then, you could have the Name field be a Report Filter. No need to manually separate all the data and then build a PT on each one.
 
You must log in or register to reply here.
Back
Top