Pivot Fill In

[Guest]

When using pivot tables, Excel only fills the first cell in a particular
column for each section or category of data. Is there a way to get the pivot
table to fill all the data elements to have a completely filled in
spreadsheet? I would like to format or even possibly complete another pivot
based on the results but I can not do that unless everything is filled in.
Thanks for your help.

 

[Dave Peterson]

Not and keep it a pivottable.

You could convert the PT to values (or copy|paste special|values to a new sheet)
and then fill the cells on that copy.

See Debra Dalgleish's site for tips to fill those empty cells:
http://contextures.com/xlDataEntry02.html

 

[Guest]

Thank you! The macro on Debra Dalgleish's site was exactly what I needed. I
also needed to copy the pivot table to a new worksheet, then I could select
the left column and run the macro to fill in the missing cells. Such a time
saver!

Nicole

 

[Guest]

Thank you Dave, your macro works wonders for me!

Nicole

 

[Dave Peterson]

Glad it worked for you.

Thank you Dave, your macro works wonders for me!

Nicole