Need only data that is within a pivot table

[tlstephe]

I've created a pivot table from a large set of data.
I need to have a tab in the workbook that only has the sub-set of raw data that is within the pivot table, not the mass set.
Does anyone know how this can be accomplished?

[Estevaoba]

Not sure I understand what you are trying to accomplish, but you could try dynamic ranges.
Assuming your pivot table starts in Sheet1!A2, try this for a dynamic range:

=OFFSET(Sheet1!$A$2,,,COUNTA(Sheet1!$A$2:$A$1000),COUNTA(Sheet1!$A$2:$Z$2))

Good luck!