M
MarkM
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.
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.