View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sas
 
Posts: n/a
Default Copying Pivot Tables from one workbook to another

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?