I've got a few pivot tables and I'd like to do the following:
Change the pivot table page based on a cell reference elsewhere in my workbook.
I've got a combo box on a separate sheet that the user will make his selection from, and GETPIVOTDATA cells on this same sheet. When the user selects the value, I want to update the page on the pivot table automatically without the user needing to manually refresh the table.
Thanks
Change the pivot table page based on a cell reference elsewhere in my workbook.
I've got a combo box on a separate sheet that the user will make his selection from, and GETPIVOTDATA cells on this same sheet. When the user selects the value, I want to update the page on the pivot table automatically without the user needing to manually refresh the table.
Thanks