ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Creating worksheet reports from a pivot table (https://www.excelbanter.com/excel-worksheet-functions/239804-creating-worksheet-reports-pivot-table.html)

Donna

Creating worksheet reports from a pivot table
 
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?

Bernie Deitrick

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?




All times are GMT +1. The time now is 06:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com