Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Controling a Pivot Dropdown
I have an excel workbook with 2 worksheets named Pivot & Summary.
The Pivot worksheet contains a large & cumbersome pivot table which contains dated information. One of the page dropdowns on the pivot table is a month selector. The summary worksheet picks off relevant data from the pivot table on the Pivot worksheet and displays in an easy to read format. As it is, to view a different month's data, I have to select the Pivot worksheet, change the month and then go back to the summary worksheet to view the change. My question is, can I control or change the Month drop down control from the Summary worksheet? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table active dropdown | Excel Worksheet Functions | |||
Pivot Chart Dropdown Question | Excel Programming | |||
pivot dropdown list limits | Excel Discussion (Misc queries) | |||
controling a .xls from another .xls | New Users to Excel | |||
pivot dropdown list | Excel Worksheet Functions |