Pivot Table based on Active Cell

  • Thread starter Thread starter Thomp
  • Start date Start date
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
 
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
Corrupt files due to pivot remnants after saving via VBA 0
Pivot Table Question 2
Expand and collapse 2
Help list box to update pivot table 1
Link Drop Down list with Pivot Table 3
How I can set dynamic pivot table ONLY when I have enough data point 1
Link Drop Down list with PIVOT Table in Excel 2003 0

Back
Top