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

Hi

If you make Department a Page field, then from the PT toolbar dropdown,
select Show pages, it will create a separate PT fro you for each
Department.

--
Regards

Roger Govier


"Terry Tipsy" wrote in message
...
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

Thanks for the response. Now that you mention it I remember seeing this
option. But for the life of me, even with your explanation, I can seem to
find it. I've dropped the department field in the page area but can't find
the option when looking through the 'Pivot Table Wizard' options. Can you
suggest what I might be doing wrong?
--
T Tipsy


"Roger Govier" wrote:

Hi

If you make Department a Page field, then from the PT toolbar dropdown,
select Show pages, it will create a separate PT fro you for each
Department.

--
Regards

Roger Govier


"Terry Tipsy" wrote in message
...
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

I must really be Tipsy. I found it by right clicking within the pivot table.
The toolbar had been hidden. Thanks again for your response.
--
T Tipsy


"Terry Tipsy" wrote:

Thanks for the response. Now that you mention it I remember seeing this
option. But for the life of me, even with your explanation, I can seem to
find it. I've dropped the department field in the page area but can't find
the option when looking through the 'Pivot Table Wizard' options. Can you
suggest what I might be doing wrong?
--
T Tipsy


"Roger Govier" wrote:

Hi

If you make Department a Page field, then from the PT toolbar dropdown,
select Show pages, it will create a separate PT fro you for each
Department.

--
Regards

Roger Govier


"Terry Tipsy" wrote in message
...
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