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.