Hello - I'm trying to change the filter in a pivot table depending on a cell value in a different worksheet in the same workbook. The pivot table should update when activating the worksheet "B" with the pivot table. The pivot table contains following data - company code, year, period, account...
Hello - I'm trying to change the filter in a pivot table depending on a cell value in a different worksheet in the same workbook. The pivot table should update when activating the worksheet "B" with the pivot table. The pivot table contains following data - company code, year, period, account...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.