Create New Worksheets based on Pivot table data
 

Here's the scenario... I have a pivot table that contains the following row
headings:

MANUFACTURER
DESCRIPTION
MFG #
UNIT PRICE

Then the Data portion are the following headings:

Sum of Quantity Shipped
Sum of Amount (Total)

I have the records sorted descending by the total. On the records that have
multiple unit prices for the MFG #, when I double-click on the total amount
for a specific unit price it will open up in another sheet all of the records
that pertain to that unit price. Is there anyway programatically to get all
of the records (every unit price for the MFG # its detail) into one sheet
instead of having to double click each one and combine them into one sheet?

Thanks :o)

Create New Worksheets based on Pivot table data
 

Mke MFG # a page field.

Thene on the Pivot Table toolbar, click the pivot table button and at the
bottom of the dropdown menu, select "Show Pages" and in the subsequent
dialog, select the MFG # page field.

--
Regards,
Tom Ogilvy


"Dee" wrote:

Here's the scenario... I have a pivot table that contains the following row
headings:

MANUFACTURER
DESCRIPTION
MFG #
UNIT PRICE

Then the Data portion are the following headings:

Sum of Quantity Shipped
Sum of Amount (Total)

I have the records sorted descending by the total. On the records that have
multiple unit prices for the MFG #, when I double-click on the total amount
for a specific unit price it will open up in another sheet all of the records
that pertain to that unit price. Is there anyway programatically to get all
of the records (every unit price for the MFG # its detail) into one sheet
instead of having to double click each one and combine them into one sheet?

Thanks :o)

Create New Worksheets based on Pivot table data
 

Thanks :o). I don't suppose there is a way to programatically do this for
ONLY the MFG#'s that more than 1 unit price listed is there???

"Tom Ogilvy" wrote:

Mke MFG # a page field.

Thene on the Pivot Table toolbar, click the pivot table button and at the
bottom of the dropdown menu, select "Show Pages" and in the subsequent
dialog, select the MFG # page field.

--
Regards,
Tom Ogilvy


"Dee" wrote:

Here's the scenario... I have a pivot table that contains the following row
headings:

MANUFACTURER
DESCRIPTION
MFG #
UNIT PRICE

Then the Data portion are the following headings:

Sum of Quantity Shipped
Sum of Amount (Total)

I have the records sorted descending by the total. On the records that have
multiple unit prices for the MFG #, when I double-click on the total amount
for a specific unit price it will open up in another sheet all of the records
that pertain to that unit price. Is there anyway programatically to get all
of the records (every unit price for the MFG # its detail) into one sheet
instead of having to double click each one and combine them into one sheet?

Thanks :o)