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.
Quote:
|
Originally Posted by 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?
|