Pivot table, assigning a cell wo be change the Pivot table filter
I was wondering if there was a way to have the pivot table pick up from a cell, the Field criteria that the Pivot table filters on.
So if you were generatering pivot tables with auto makers, and you had 4 tables. and i wanted to filter it on ford, I would have to go to the maker criteria filter and select only the Ford, for each table,
So I was wondering if I was or could designate a cell and either by a macro or based on the cell? Come to think about it, it's probable a macro. Or is there way to change one filter and they all follows.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1