Macro on a Pivot Table

L

Lucas B

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copy a pivot table to another sheet in a macro 1
Run Macro Automatically When Excel 2003 Opens 2
Pivot table - undo of a macro 1
Refreshing Pivot Table on a protected spreadsheet tab 1
How do I replace/select new fields in pivot table using a macro? 1
Wait statement in macro 1
Dynamic pivot table 1
Scenarion Manager Crashes with Pivot Table option 1

Top