I'm not sure I understand, but maybe you could copy the pivottable to a new
sheet, paste special|Values and do the formatting the way you want.

You could even continue recording your macro while you do all this stuff.

MB wrote:

Thanks Dave,

My real issue was that I could not figure out a way to organize the data and
rows the way I need. The rows and columns are placed together then the data
area. I need the data to come after each row heading. Right now my
pivottable reads:
PERS DTYPE Freq Pct Freq Pct
ACE ZD 3 15% 5 25%

Example:
PERS Freq Pct DTYPE Freq Pct
ACE 3 15% ZD 5 25%

I just need to figure out how to merge data with rows.
Thanks,
Michael

"Dave Peterson" wrote:

I'm not sure what you want to do. But as an alternative, you may want to record
a macro when you create the pivottable. Then just run the macro when you want
to regenerate the pivottable.

MB wrote:

How do I create my own PivotTable template?

--

Dave Peterson

--

Dave Peterson