Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Looping page fields in pivot table

I have a pivot table with five page field filters. I'm trying to find
some code that will automatically cycle through all of the filtering
permutations, copy a chunk of cells that are fed by the pivot table
results with each change, and pass it to another worksheet (--pasting
each new data run below the previous one).

BUT, only ~200 of the total number of permutations have underlying data
to be used. So, I want to cycle through a specific list of of page
field selection on a separate sheet.

Any thoughts?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Interdependent page fields in one pivot table MaryC Excel Discussion (Misc queries) 2 August 9th 06 07:09 PM
Looping page fields in pivot table [email protected] Excel Programming 1 March 14th 06 12:46 AM
Pivot Table Page fields Ajit Excel Discussion (Misc queries) 1 October 12th 05 05:49 PM
Pivot Table page fields Chad W. Excel Discussion (Misc queries) 1 July 27th 05 04:27 PM
Pivot Table Page Fields Andy Excel Discussion (Misc queries) 1 December 17th 04 05:25 PM


All times are GMT +1. The time now is 07:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"