[pivottables] multiple table selection fields update in one click...
Hi
On a worksheet, I have 100 pivot tables. Let's say one criteria of each pivot table is "month" Ho can I do in order to only type somewhere the month (let's say in A1 for example) and this month is then automatically populated to all pivot tables ? If this is easy... additional question : on the same worksheet, I have 100 pivot tables split in two columns. with the same "month "criteria. How can I do to have A1 for month setting for the 50 pivot tables of the 1rst column, and A2 to setup the month of the other 50 pivot table list ? Thanks, AL. |
[pivottables] multiple table selection fields update in one click...
There's a sample file here where changing a page field in one pivot
table changes the same field in other pivot tables: http://www.contextures.com/excelfiles.html Under PivotTables, look for 'PT0008 - Change Multiple Page Fields' It might help you get started with your workbook. wrote: Hi On a worksheet, I have 100 pivot tables. Let's say one criteria of each pivot table is "month" Ho can I do in order to only type somewhere the month (let's say in A1 for example) and this month is then automatically populated to all pivot tables ? If this is easy... additional question : on the same worksheet, I have 100 pivot tables split in two columns. with the same "month "criteria. How can I do to have A1 for month setting for the 50 pivot tables of the 1rst column, and A2 to setup the month of the other 50 pivot table list ? Thanks, AL. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
All times are GMT +1. The time now is 04:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com