gregoryjgold
New Member
- Joined
- Sep 22, 2014
- Messages
- 2
Hi,
I have multiple pivot tables that are summarizing a large table with different filters. They are on top of each other and separated by headings. The problem is that if a new row is added to the table and the pivot table is refreshed it will overwrite on the next available line below the pivot table and eventually overwrite the headings. I am hoping that there is a way to have a more dynamic output range where a new row resulting from the pivot table refreshing will just push the remaining stuff down a row rather than overwriting it. Is this possible? Any advice would be greatly appreciated.
Thanks in advance,
Greg
I have multiple pivot tables that are summarizing a large table with different filters. They are on top of each other and separated by headings. The problem is that if a new row is added to the table and the pivot table is refreshed it will overwrite on the next available line below the pivot table and eventually overwrite the headings. I am hoping that there is a way to have a more dynamic output range where a new row resulting from the pivot table refreshing will just push the remaining stuff down a row rather than overwriting it. Is this possible? Any advice would be greatly appreciated.
Thanks in advance,
Greg