Pivot Fill In

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
Back
Top