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)