+ Reply to Thread
Results 1 to 1 of 1

Create Multiple Pivot Tables VBA

  1. #1
    Forum Contributor
    Join Date
    Richmond, VA
    MS-Off Ver
    Excel 2007

    Create Multiple Pivot Tables VBA


    I need multiple pivot tables to be created from one data source. The only difference between each pivot table, is the value that is selected in the report filter. So each pivot table will include the EXACT same fields in the same pivot table field. Each pivot table will have its own tab. The data source for each pivot table needs to be dynamic (the number of rows will change all the time), but the columns are fixed. The column range for the pivot table is A:G, but like I said, the # of records will vary.

    So this is what I need:
    • For every UNIQUE value in column A – create a pivot table in a NEW sheet and use the unique value in column A as the report filter value.
    • Document Name --> Report Filter
    • Month Name --> Column Label
    • Name of User --> Row Label
    • Count “Name of User” --> ∑ values

    Please see the attached workbook for an example of what I need.

    If you have any questions at all, please let me know. Need some help
    Attached Files Attached Files
    Last edited by bcn1988; 03-15-2013 at 12:52 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1