Hi,
Apologies i've searched all over the forum and cannot seem to find an answer to this.
Is there a way in VBA I can control the filter of my pivottable based on the value in a text box or even based on an array of items in a list box?
Any help would be much appreciated
Cheers
Chris
Apologies i've searched all over the forum and cannot seem to find an answer to this.
Is there a way in VBA I can control the filter of my pivottable based on the value in a text box or even based on an array of items in a list box?
Any help would be much appreciated
Cheers
Chris