Export to excel with grouping functionality

[sibideepak]

Hi All,

Need to export an pivot table to excel with grouping functionality. Any macro can do this ?

I'm trying to get this done for so long time,Help me out very urgent.

Thanks,

Deepak

[Gysbert_Wassenaar]

Search for VBA + Excel + Group using your favorite web search engine. You should be able to translate the VBA to Vbscript without to much trouble.

Perhaps this helps: http://stackoverflow.com/questions/13337267/grouping-rows-in-vba

[sibideepak]

Any other work around for this ?

[Gysbert_Wassenaar]

Sure, pay somebody to do it for you