Hi,
Found this artical and it does what I need to a point.. I would contact the author but cant find anywhere with email address or a link to set up a username to post on the artical...
Here it is...
How to control Excel PIVOT tables from a cell value with VBA | dedicatedexcel.com
Basically you add your filter to a cell and the pivot table filter updates...
I need this exact solution however I have 20 items that I need to be added to the filter. I need to replicate the same filter list in around 25 pivot tables in a worksheet.
The user needs the ability to update 1 list and all the pivot tables filters are updated...
Can anyone amend the code to accept more than the 1 filter entry?
thanks
James
Found this artical and it does what I need to a point.. I would contact the author but cant find anywhere with email address or a link to set up a username to post on the artical...
Here it is...
How to control Excel PIVOT tables from a cell value with VBA | dedicatedexcel.com
Basically you add your filter to a cell and the pivot table filter updates...
I need this exact solution however I have 20 items that I need to be added to the filter. I need to replicate the same filter list in around 25 pivot tables in a worksheet.
The user needs the ability to update 1 list and all the pivot tables filters are updated...
Can anyone amend the code to accept more than the 1 filter entry?
thanks
James