Forum Discussion

Copper Contributor

Nov 13, 2021

vba move pivot table automatically when expanding rows

PLEASSSS Can someone help me? I need a vba code that move a pivot table automatically when expanding rows. I know that is possible, but i don´t know nothing about VBA.

excel

Macros and VBA

2 Replies

Yea_So
Bronze Contributor
Nov 14, 2021
why don't you just put each pivot table on separate sheets and create a button with a link to that sheet when you need to view the pivot table, its much easier than what you're thinking of doing
- Rai__LS
  Copper Contributor
  Nov 15, 2021
  It's because I need to see all the tables in a single view screen.