Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table question
A book that will show you exactly what you are asking is: Excel 2002 Power
Programming with VBA by John Walkenbach. It is EXCELLENT...... "John Thomas" wrote in message ... Hi all, I have a pivot table that shows Project information like this: Project Plan ------- ----- ProjectA $200 ProjectB $300 ProjectC $500 Is it possible to filter the pivot table to just 'ProjectB' while opening the excel spreadsheet. The project that needs to be shown (in this case) should be a parameter to the spreadsheet. If the parameter is 'ProjectB' then the pivot table would show: Project Plan ------- ----- ProjectB $300 Any good books on programming pivot tables / charts? Thanks, John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Question | New Users to Excel | |||
Pivot Table Question | Excel Worksheet Functions | |||
Pivot Table Question | Excel Worksheet Functions | |||
Pivot Table Question : If statment in Pivot Table?? | Excel Discussion (Misc queries) | |||
Pivot Table Question | Excel Worksheet Functions |