pivot tables - set up one pivot cache, and then create tables

Hi, I'm trying to create a number of pivot tables - the specific tables that are created are dependant on tick boxes from a userform.

I figured the easiest way to do this (and most memory efficient) would be to set up one pivot cache, and then create the tables from this.

It should be relatively simple, but I'm struggling!

Here's my code so far...

Please Login or Register  to view this content.

Cheers

Charlie

I've played with creating pivot tables in the past. See if this helps:

Raw data on sheet 1. Column headings (A1:F1) - Order no, Activity code, Duration, OMS no, Name, Date

The code for manipulating the pivot table fields (the code between With pvtTable1...End With) can be obtained by recording a macro while creating a pivot table.

Please Login or Register  to view this content.