Hi guys,

This can be a easy task but I couldn't find any suitable solution online.

I have a PivotTable ("pivotreport") with many fields like Clients, Projects, Products... In the same worksheet 2 comboboxes (clientfilter and projectsfilter) and a command button named "Filter".

I want to configure the code for the Filter button to perform the same action as the slicers do - filtering the table field according to the comboxes value. Is this a hard task?

Thank you in advance for any help!