Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot tables - All Change with Validation List
Hi,
I have an Excel workbook with several sheets in it. I have the following sheets: Summary Totals Orders Refunds Basically, I need the summary sheet to show me values from each sheet, which is actually the Grand Total of each pivot table (one per sheet).. I have done this no problem, however, I want to have this table on the summary sheet as interactive, so if you choose UK from a validation list on the summary sheet, I want all the pivot tables to update to filter on UK (which is the Page filter) and therefore the grand totals showing on the summary page would be for UK data, then if I pick France, all pivot tables would change to be French data.. Can anyone help me? Thanks and Happy Holidays, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot tables - All Change with Validation List
You can do this with programming. There's a sample file he
http://www.contextures.com/excelfiles.html Under PivotTables, look for 'PT0016 - Change Page Fields With Cell Dropdown' Louise wrote: Hi, I have an Excel workbook with several sheets in it. I have the following sheets: Summary Totals Orders Refunds Basically, I need the summary sheet to show me values from each sheet, which is actually the Grand Total of each pivot table (one per sheet).. I have done this no problem, however, I want to have this table on the summary sheet as interactive, so if you choose UK from a validation list on the summary sheet, I want all the pivot tables to update to filter on UK (which is the Page filter) and therefore the grand totals showing on the summary page would be for UK data, then if I pick France, all pivot tables would change to be French data.. Can anyone help me? Thanks and Happy Holidays, -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot tables off a List | Excel Discussion (Misc queries) | |||
Where has my field list gone for my Pivot Tables? | Excel Worksheet Functions | |||
PIVOT TABLES-PERCENT/AMOUNT OF CHANGE | Excel Worksheet Functions | |||
Working with Pivot tables with % change | Excel Worksheet Functions | |||
Validation Tables For Drop Down list on a Separate Worksheet. | Excel Worksheet Functions |