VB MACRO for Multiple Pivot Table

[isudheera]

Dear Experts ,

Can anyone explain me to write macro with looping to create multiple Pivot table in different tabs from one pivot source ( My pivot source extended to two work sheet since excell row limitation of 65K). I have attached excel files and insert two pivot tables as I required.
I have variable from X1 to X33 in my rows and I need pivot table Name in Row label, Time in Colum label and X1 in Values Field (value filed must be summarized as Sum)
I need 33 Pivot tables in different tabs while keeping constant Row label and Colum label as name and time , and changing value field (value filed must be summarized as Sum) from X1 to X33.

I have inserted two pivot table for get it clear my requirement.

Thanks and Regards.

NNNN

[AlphaFrog]

Please Login or Register  to view this content.

[isudheera]

Dear AlphaFrog ,

Thank you very much for your coding . It is perfectly working.

NNNN

[isudheera]

Dear AlphaFrog ,

Can you give give differant macro for update mulipale pivot range and copy and paste all pivot date as value on same location once source date updated .

Thank you very much for your help.

NNNN

[isudheera]

Dear Experts,

My Pivot source data extended to another worksheet since excell row limitation. Can you guide me edit pivot case.So pivot cache.

NNNN