Dynamic location for pivot table

M

Michael Dobony

I have a workbook with several pivot tables lined up from top to bottom for
printing out. The problem is the spacing. Is there a way to automatically
start PivotTable2 three lines below PivotTable 1 and on down? I tried the
offset with PivotTable1 as the starting point, but that doesn't work.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUM & OFFSET & PIVOT TABLE?? 0
VBA Pivot Table Error 1
Playing back a Pivot Table macros 2
Pivot Table Macro with dynamic source data 1
How I can set dynamic pivot table ONLY when I have enough data point 1
Pivot Table Page Change Code 1
Using macro to switch 'page' in a pivot table? 1
Change report firlds in pivot tables and charts with one selection 0

Top