Pivot maco

Hi,

I am trying to create a pivot table using Macro. the code working fine.. but the "values" field in "Row label" insted of "column label.

Can any one help me this.

i have attache the excel file..

* Out put sheet contains actual output i need
*Information sheet contains, the information which need to be pivot.
*pivot sheet contains the macro output...

Thanks

Regards

Jack

Put this at the bottom of your pivot table macro and it should move the pivotinfo to the column label.

Please Login or Register  to view this content.