P
Paul Willaims
I have been asked if it is possible to create a macro to
do this
sheet 1 has a pivot table direct from a data source with 5
totals (a,b,c,d,e).
sheet 2 =a
sheet 3 =b
sheet 4 =c
and so on.
We are looking for a macro to refresh the pivot table,
then go to each sheet and pause for 1 minute on each sheet
in a continous loop all day.
Thanks in advance.
do this
sheet 1 has a pivot table direct from a data source with 5
totals (a,b,c,d,e).
sheet 2 =a
sheet 3 =b
sheet 4 =c
and so on.
We are looking for a macro to refresh the pivot table,
then go to each sheet and pause for 1 minute on each sheet
in a continous loop all day.
Thanks in advance.