Pivot Tables: Can I get cells to duplicate downward automatically?

[StrawberryGirl]

I am currently using PivotTables and am wondering if there is a way for the
table to automatically appear with all of the cells 'filled-in' down a column
without having to do it manually after it appears?

 

[Peo Sjoblom]

Do you mean when the source data has been changed? If so you can use a
dynamic table and refer to it then just refresh the pivot table

there are instructions for here

http://www.contextures.com/xlPivot01.html


Regards,

Peo Sjoblom