Pivot Table Question

[Jason Chang]

How do I make the row headers show up in front of each row
on pivot table instead of just once on the first row of a
section?

Thanks

 

[Max]

Try this:

Copy the pivot table
Do a Paste Special > Values into another sheet

Ensure that the top left cell is A1

Run the Sub FillBlanks() below
(from MVP Debra D)

Sub FillBlanks()
'by Debra Dalgleish 7-Dec-2001
'fill blanks cells with data from above
Range("A1").CurrentRegion _
.SpecialCells(xlCellTypeBlanks) _
.FormulaR1C1 = "=R[-1]C"
Range("A1").CurrentRegion.Copy
Range("A1").PasteSpecial Paste:=xlPasteValues
Application.CutCopyMode = False
End Sub

hth
Max

 

[Dave Peterson]

I don't think you can do it and keep the pivottable.

I like to get the pivottable nicely formatted and then I'll copy|paste special
values (either right over it or on a new sheet).

From there I can fill those empty cells.

Debra Dalgleish has a technique documented at:
http://www.contextures.com/xlDataEntry02.html