Forum Discussion

Copper Contributor

Oct 24, 2021

Expand Excel PivotTable without overlaying another PivotTable (VBA)

Hi guys, please help me. I need to expand my Excel pivot table without overwriting the other pivot table below. Is it possible to do this using VBA? Would anyone have the code? I need that when I cli...

excel

Formulas and Functions

Macros and VBA

Yea_So

Bronze Contributor

Oct 24, 2021

Rai__LS

move it

Rai__LS

Copper Contributor

Oct 27, 2021

I need this to be automatic, do the opposite every time I expand the table I will have to move it manually.

Yea_So
Bronze Contributor
Oct 27, 2021
Rai__LS

Pivot table expand going down and going right. so what part of the worksheet can you put something that will not get affected with the expansion, find that place.
- Rai__LS
  Copper Contributor
  Nov 13, 2021
  Yah, i know that, is because of that i need do it using a VBA code. I´m looking for this code in the web.
  - Yea_So
    Bronze Contributor
    Nov 14, 2021
    you don't need VBA to find that place, that place is to the left of the location of the pivot table will not be affected by the expansion/contraction of the pivot table.