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?
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?
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!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks