Consulting

Results 1 to 3 of 3

Thread: Solved: Generating a Pivot thru VBA (Summary)

  1. 03-27-2009, 12:32 AM #1
    rangudu_2008
    rangudu_2008 is offline
    VBAX Contributor rangudu_2008's Avatar
    Joined
    Apr 2008
    Posts
    150
    Location

    Solved: Generating a Pivot thru VBA (Summary)

    Hi,
    Is it possible to generate a pivot table thru VBA as in the attachment?
    Thanks for any sort of help in advance.

    Ranga
    Reply With Quote Reply With Quote
  2. 03-27-2009, 04:10 PM #2
    mdmackillop
    mdmackillop is offline
    Administrator
    VP-Knowledge Base     VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,489
    Location
    Moved to a new thread.
    MVP (Excel 2008-2010)

    Post a workbook with sample data and layout if you want a quicker solution.

    To help indent your macros try Smart Indent

    Please remember to mark threads 'Solved'
    Reply With Quote Reply With Quote
  3. 04-04-2009, 07:47 AM #3
    rangudu_2008
    rangudu_2008 is offline
    VBAX Contributor rangudu_2008's Avatar
    Joined
    Apr 2008
    Posts
    150
    Location
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules