PDA

View Full Version : Solved: Generating a Pivot thru VBA (Summary)



rangudu_2008
03-27-2009, 12:32 AM
Hi,
Is it possible to generate a pivot table thru VBA as in the attachment?
Thanks for any sort of help in advance.

Ranga

mdmackillop
03-27-2009, 04:10 PM
Moved to a new thread.

rangudu_2008
04-04-2009, 07:47 AM
I've developed some code (attached) for generating a pivot report.
How can this be modified in such a way that just by passing the source & destination sheet names?

Ranga