I've been tasked with finding a way to filter a Pivot Table filter field based on the userid of the person accessing the pivot table. I'm using VBA and I know how to get the userid, I can build a list of "options" based on that userid but have not figured out a way to then change the "options" in the filter based on that newly generated list.
I can access the filter field I want by using PivotFields(index) but I don't know how to access the contents of the field or how to change what's in there even if I could.
Is there a way to do this? Am I even making any sense at all? Any help would be greatly appreciated. I feel like I'm driving blind!
Thanks,
I can access the filter field I want by using PivotFields(index) but I don't know how to access the contents of the field or how to change what's in there even if I could.
Is there a way to do this? Am I even making any sense at all? Any help would be greatly appreciated. I feel like I'm driving blind!
Thanks,