I create a pivot table from a worksheet where there is row data like:
Date - Product - Quantity
The pivot table shows the product in the rows and the date in the
columns and finally display the sum of the quantity in the middle. (I
hide the column for all the previous date and only keep the current
date, but unfortunately I can only hide the other date as their
quantities are used in the calculation)
My problem is if I've got more than 255 dates (I want to display the
information on one year) the last data are shrinked from the pivot
table and I lose the information. I can still reverse rows and column
(there are less than 255 products) but it hard to read the pivot table.
Is there a way to copy only the displayed cells (not hidden) and paste
them in the a different sheet. And moreover is it possible to invert
the rows and columns?
Bookmarks