The Cross post here:
http://www.mrexcel.com/forum/showthread.php?t=344223
Hi,
I have about 20 sheets in a workbook. I need to create pivot for all the data in each sheets. the Data, Column & Rows in pivot are same ( table contents are same for all the pivots) contents in table are different in each sheets. one sheet may have 2 rows, another sheet may have 35 rows, etc,
I have recorded a macro for one sheet, do not know how to apply the same in all the sheets.
the code is
Is there a way that we run a macro, the pivot is automatically created in all the sheets, and the pivot table should appear in the existing sheet just after the data.
I have attached the sample file for 2 sheets one with the pivot created and the other is without pivot.
Arvind....
Bookmarks