Add Pivot Table Filters to current UserForm code.

Hi,

I am trying to utilize my current code to also add a filter to a Pivot Table field. Currently the code filters the worksheet, but now I need to filter the pivot table to provide data analysis through charts/graphs.

I need to be able to do both, filter worksheet and filter pivot tables.

I have uploaded an example version and screen shot to give an idea.

I appreciate all the help in advance. I've made so much progress thanks to many of the forum contributors.

Thanks!

Hi,

I really struggled with this one, until I was informed that one cannot use an array within a Pivot Filter!!
TX to HansV at Eileen's Lounge, I have the code for you... (http://www.eileenslounge.com/portal.php)
Attached is the workbook file with functional sample.

I wondered if you were the same Rudi.

Hi Rory,
The one and only