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 |
All times are GMT +1. The time now is 05:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com