Hi Guys,
Hope everyone's having an awesome Tuesday!
I have a dilemma that for the life of me, can't figure out. Your help/advise would be greatly appreciated
So I've this pivot table which I've been manually right clicking on the values and selecting 'Show Details' to compile the source data. I can't figure out how to to open up the source data on a mass basis (rather than one by one manually) and have it all auto-compiled into a single worksheet or tab within the same workbook.
Can anyone please advise the best way to go about doing this?
<colgroup><col><col></colgroup><tbody>
</tbody>
Regards,
Rayvin
Hope everyone's having an awesome Tuesday!
I have a dilemma that for the life of me, can't figure out. Your help/advise would be greatly appreciated
So I've this pivot table which I've been manually right clicking on the values and selecting 'Show Details' to compile the source data. I can't figure out how to to open up the source data on a mass basis (rather than one by one manually) and have it all auto-compiled into a single worksheet or tab within the same workbook.
Can anyone please advise the best way to go about doing this?
Vendor | Total |
PHELM | 25 |
PHELM | 24 |
PHELM | 24 |
PHELM | 21 |
GBORR5 | 14 |
<colgroup><col><col></colgroup><tbody>
</tbody>
Regards,
Rayvin