Macro to create pivot tables for each Cost Code

[curly]

Hi & Morning!

I'm not very advanced at all with Macros but I need one to assist me with a large project.

I have found a macro to create a single worksheet for each cost code in a column of data - Part One Complete!

xxxx

I have a large set of data which is similar to below

Column
A - Emp No
B - Salary
C - Gender
D - Job Family
E - Job Family 2
F - Business Unit
G - Cost Code

I need a macro to create a single pivot table for each cost code (of which there are 152).

I'd like the Pivot to look like this

Row
F - Business Unit
G - Cost Code
D - Job Family
E - Job Family 2

Column
C - Gender

Data
B - Average Salary

The end result will be 152 pivot tables all based on the criteria above. Is this possible?

Thank You in advance

Em x

 

[GlennUK]

Why don't you pivot the entire set of data, put the cost code in a page field and then do the Show Pages command ( or Show Filter Report Pages in Excel 2007 ), which will generate a pivottable for each cost centre. ( you don't need it in the body of the pivottable as each one will be for a single cost centre )