View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
 
Posts: 1,180
Default Copying values from pivot table to cells outside pivot table

RightClick on "Code" Field Settings Advanced
AutoSort Manual
Click on "REG"
Mouse over the cell until you get a 4-headed arrow.
Drag the cell to where you want it.