Hi All,
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.
thanks
James