Pivot Table based on Active Cell

T

Thomp

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
 
P

Patrick Molloy

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unable to Group in Pivot Table 1
Pivot Table Question 2
Help list box to update pivot table 1
Update Pivot Table Filters based on a Cell Value in Excel 2007 0
Expand and collapse 2
Pivot table multiple filters 2
How I can set dynamic pivot table ONLY when I have enough data point 1
Link Drop Down list with Pivot Table 3

Top