ExcelBanter - Macro on a Pivot Table

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Macro on a Pivot Table (https://www.excelbanter.com/excel-discussion-misc-queries/251683-macro-pivot-table.html)

Lucas B

Macro on a Pivot Table

I need to write a macro that takes the results of a pivot and creates detail
tabs for all results that are greater than or equal to 20. I was able to
record a macro that created the detail tabs for cells that I specifically
double clicked on, but the data will change monthly and I need this to select
only applicable cells. Any suggestions?

Herbert Seidenberg

Macro on a Pivot Table

Excel 2007 PivotTable
List source details that have PT results of 28<=x<=32
http://c0444202.cdn.cloudfiles.racks.../12_22_09.xlsm

All times are GMT +1. The time now is 07:50 AM.