Hello everyone,
I am trying to export a list of filtered results from a pivot table. I have tried .visible .visibleitems, but I keep getting all 10 rows, instead of the 5 from the filtered pivot table that I want.
I have attached an image that shows the data and pivot table. Thanks in advance.
Here is the VBA...
datafrompivot.pngPlease Login or Register to view this content.
Bookmarks