Pivot table - repeating layout

[oolaef]

All,

Is it possible to automatically cap the amount of rows a pivot table will extend down, and then have it repeat from the top again alongside, to the right? I'm looking to create a report that is printed on an A3 sheet of paper every week, and the default behaviour of extending the table down until all values are shown doesn't lend itself to this format.

I can create multiple tables side by side with varying values filtered out to limit the length of the tables, but since the amount of rows are changing week-to-week the filters would need to be manually adjusted.

Any help appreciated!

[PFDave]

You can use the value filters option to select the top or bottom X values. This would need to be changes depending on your data set.

You could arguably use VBA to count the rows and work out what the top and bottom numbers for that filter would be.