I have a pivot table that I want on the same sheet as the data. However when a user enters a new row on the top of the chart, which is where they need to add the row, the pivot table moves down.
I will have users entering in a ton of new rows at top, and then the pivot table will be moved all the way down to the bottom--off the screen and won't be seen unless they scroll.
pivot table.jpg
So here the pivot table starts at G8. I want it to stay in G8 even when a row is added on the top of the chart, rather than moving down to G9.
How can I do this?
Bookmarks