ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Insert a row after a pivot table (https://www.excelbanter.com/excel-discussion-misc-queries/100204-insert-row-after-pivot-table.html)

MarkM

Insert a row after a pivot table
 
I have a sheet with many pivot tables on it I use for pivot charts. When I
update the pivot table the table expands and bumps into the next table on the
sheet. I have the tables listed vertically on the sheet. The tables are
going to expand vertically by month so I know I could just insert 12 or so
lines between each pivot table but I figure there must be a way to have a
macro insert a line after each pivot table before it updates all tables. I
have a macro built that refreshes all tables then fixes the formats on the
charts with the click of one button. My sheet with the tables is laid out
like this:

Table1
Columns of Sales Data
Month1
Month2

Table2
Columns of Sales Data
Month1
Month2

How can I tell it to look for the last row of the pivot table and then
insert a row? Or is there a better way to accomplish what I am trying to do
which is to insert a row instead of overwrite the row when the pivot table is
refreshed.

Thanks in advance for you help.



All times are GMT +1. The time now is 01:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com