![]() |
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