Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table active dropdown | Excel Worksheet Functions | |||
Update a cell based on the pivot table refresh date | Excel Programming | |||
Drag formula based on pivot table cell | Excel Discussion (Misc queries) | |||
Select all pivot table areas/ranges on the active sheet problem | Excel Programming | |||
Select First Active Cell if the cell is in a pivot table | Excel Programming |