Pivot Table based on Active Cell
 

I have a pivot table that instead of using the drop down to select the
data I wish to filter on I want the pivot table to fitler based on an
the active cell data. Is this possible? Thanks in advance for your
help

Pivot Table based on Active Cell
 

similar questions on Pivot Tables have been answered in the last couple of
months I'm sure - have you searched this news group?

"Thomp" wrote:

I have a pivot table that instead of using the drop down to select the
data I wish to filter on I want the pivot table to fitler based on an
the active cell data. Is this possible? Thanks in advance for your
help