|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
Repeating Row Fields in a pivot table
Nope.
maghraby wrote:
Thank Max for this.
But this solution is only applicable if i copy my pivot table data and paste
in a new sheet which is not viewed as a pivot table. Is there a way to do
this as an option for pivot tables?
"Max" wrote:
Try Debra Dalgleish's page for
some nice ideas on filling in the blank cells:
http://www.contextures.com/xlDataEntry02.html
Fill Blank Cells
Fill Blank Cells Programmatically
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"maghraby" wrote:
Is it possible to get my row fields to repeat with every row instead of
having the row field appear once as a header for all related data?
example:
in a sales table by area:
ROWS COLOMS
Area1 11111
22222
31142
Area2 45354
54534
===================
Can I get "Area1" to repeat with all its sales values and so Area2 too?
--
Dave Peterson
|