Hi Guys!
Please, i need your help ...
I need a code to filter an OLAP Pivot Table based on a value from a cell from another worksheet.
On sheet1 cell c6 i insert the name of the city. On sheet2 i have an OLAP Pivot Table which have a filter "city". I would like to have a code which automatically filter the pivot table based on the name of the city i insert in cell c6 from sheet1.
Can anybody help?!
Please, i need your help ...
I need a code to filter an OLAP Pivot Table based on a value from a cell from another worksheet.
On sheet1 cell c6 i insert the name of the city. On sheet2 i have an OLAP Pivot Table which have a filter "city". I would like to have a code which automatically filter the pivot table based on the name of the city i insert in cell c6 from sheet1.
Can anybody help?!
