View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cware cware is offline
external usenet poster
 
Posts: 29
Default Pivot Table format

In my pivot table, I am listing 4 different row fields in front of the data.
In many rows, to the right of the pivot, I manually enter a code based on
what causes a difference in the two columns of data. This is manual
research. What I would like to do, however, is on a separate worksheet in
the workbook, copy the rows when the code column equals a specific code.

Also, is there a way to extend a common field to all cells instead of having
the field only show once?