Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
[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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto table feature in excel doesnt work on multiple tables | Excel Worksheet Functions | |||
Selection of multiple values for pivot table field | Excel Discussion (Misc queries) | |||
insert query into excell sheet to update excell sheet and pivot table | Excel Discussion (Misc queries) | |||
Click on graph bar to execute a double-click in a pivot table cell | Charts and Charting in Excel | |||
Graph from a PIVOT table: update not working. Please Help! | Excel Discussion (Misc queries) |