Pivot Table Overlapping Solution ?

[spsagar]

I've multiple worksheets in which there are vertically aligned multiple pivot tables and I don't want them to be horizontally aligned.

After I remove the filters, the pivot table is supposed to expand but suddenly states overlapping problem.

I've to manually leave a lot of rows blank and hide them.

Could this be done through VBA code or auto adjusting the rows to shift down after expansion of pivot table dynamically ?

PLEASE HELP !!! URGENT !!!

 

[Ron Coderre]

Without using VBA, here's what I usually do....
Assuming the pivot table begins in C7
• Leave plenty of rows between pivot tables
• A6: Status
• I put this formula in A7 and copy it down as far as I need:

A7: =IF(COUNTA(C6:C7),"SHOW","HIDE")

• Then I filter on A6 through the last test cell in Col_A and UN-check "HIDE"
After each pivot update I toggle the filtering ON/OFF

Is that something you can work with?

 

[spsagar]

I don't want to hide rows/columns.

Could you give me VBA code to auto adjust the rows after expansion of pivot table vertically ?