Copying Pivot Tables from one workbook to another

S

sas

How would I copy Pivot tables from one workbook to another? I have a
workbook of time sheets that I have to do a "study"; i.e. based on the
desciption of time spent per day per employee. I have many sheets that is
taking me forever to do them individually. I tried recording a macro for
each Pivot Table I created for each day of the week, but that did not work;
orit could be that I am not applying the maros correctly. Can anyone help me?
 
G

GarToms

I have been working with pivot tables a lot recently. I needed to
duplicated a lot at once to get a some work done quickly. To do it i
right clicked on the sheet tab at the base of the sheet and selected
copy.

You could get a load out this way but if you wanted a lot more just
record a new macro to do this.

i.e. Tools> Macro> record new macro.

go through the step of copying the sheet with the pivot table on.

Tools> Macro> stop recording.

create a button
assign the macro to that button, you can then press that to create a
load of copys.
 
Top