Thread
:
Using VBA on Excel Pivot Tables
View Single Post
#
2
Posted to microsoft.public.excel.programming
GS[_2_]
external usenet poster
Posts: 3,514
Using VBA on Excel Pivot Tables
explained :
I'm looking to be able to do the following. Sources of examples would be very
much appreciated. I've searched around and haven't been able to find.
I have a pivot table with a large number of pivot table fields (43)
For my specific application - I'm only using 9 of these. The 9 chosen will
not change. Two of the fields will be used as a row labels - representing
month/year and day
I would like to get a complete list of all of the items within each of the
other 7 which will be used as report filters.
I would like to create 7 data validation lists on another worksheet that
make use of each of these potential options within each of the 7 fields,
allowing the user to select an option from each of the data validation lists
I would then like the item selected to modify the specific items selected in
the pivot table so that it updates.
Using VBA on pivot tables is pretty new to me. So any assistance will be
appreciated
I'm having trouble trying to determine the items within each of the fields
and then once those are put into data validation ranges, using the selection
in the validation range to update the pivot.
Try here...
http://www.contextures.com/tiptech.html
--
Garry
Free usenet access at
http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc
Reply With Quote
GS[_2_]
View Public Profile
Find all posts by GS[_2_]