Hopefully, I can explain this so it makes sense. Once I have created a pivot
table, I would like to make multiple copies of the same table on different
tabs in the same worksheet. I'm looking for custom macro to accpomplish
this.

For example, I have expense detail by department and want to summarize this
information in a pivot table. I want the macro to then create other tables
in individual tabs based on the department. I would then probably copy and
paste each tab to retain the numbers and format. I will be summarizing the
data returned to me and having the sheets in a standard format will help.

--
T Tipsy