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.