View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default Creating worksheet reports from a pivot table

Donna,

Perhaps? Double-click on any data value of interest, and Excel will create
a report with all the values that go into that value.

HTH,
Bernie
MS Excel MVP


"Donna" wrote in message
...
In the most updated version of Excel there is a way of taking a pivot
table
and producing multiple worksheet reports in order to send them to
individuals.

According to what I understand this is also possible in 2003 Excel.

What are the step by step directions to do this?