I have used the Wizard to create a pivot table. I was unable to find how to
create two column headings. I can get the wizard to use either 'Account ID'
or 'Description' but NOT both. Can someone suggest the macro code that would
add 'Description' to an existing pivot table as the second line in each
column?

Something likeeither:

40100 Utilities
Utilities 40100

My existing pivot table has only the Account ID as a column heading.

Thanks,

EdC

Did you turn on the macro recorder as you ran the PivotTable Wizard
manually?
You should be able to add Account ID and Description to the Column area
in the PivotTable Wizard. What happened when you tried?


Ed C wrote:
I have used the Wizard to create a pivot table. I was unable to find how to
create two column headings. I can get the wizard to use either 'Account ID'
or 'Description' but NOT both. Can someone suggest the macro code that would
add 'Description' to an existing pivot table as the second line in each
column?

Something likeeither:

40100 Utilities
Utilities 40100

My existing pivot table has only the Account ID as a column heading.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html