ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table - Simultaneous Drill-Down (https://www.excelbanter.com/excel-discussion-misc-queries/176630-pivot-table-simultaneous-drill-down.html)

Valente

Pivot Table - Simultaneous Drill-Down
 
In a Excel Pivot Table, when we double-click a cell in the Data area,
a new sheet is created with the details.

What I want to do (I already did it in the past), is when I click a
cell in the Row area, several sheets are created (one per distinct
value).

I already had this feature in Excel in the past (I think it was an add-
on), but I don't remember how to find it or to do it again.

Thxs,,

Pedro Valente


All times are GMT +1. The time now is 10:37 PM.

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