Hi All,
I know it´s possible to kind of export the data/items from a pivottable to different worksheets/tabs.
Can't find it at the moment, and that's strange because it isn't difficult as I remember.
I managed to get the items printed seperately but this is to extract the data to the tabs.
Anybody?
thanks!
Frans
Sorry, for the second time in a short time I was too fast with my question.
Found the answer here in the PivotTable section (information of Mynda's).
You can do this when you work with a pagefilter. See: https://www.myonlinetraininghub.com/excel-pivot-tables-to-extract-data
Only thing is that I wanted the lastname as well in that filter as in the pivottable and for that you have to make a helper column with the same name in it.
So found it again here on this website. thanks!
Frans
Hi Frans,
Glad you found what you were looking for. You're right, the helper column is the way to go if you want the filter to contain first and last names.
Mynda
