I need a macro to use in a standard situation - I create (what I call) Value tables (not linked to the pivot table data) based on Pivot tables, but then add the additional rows to the Value table that need to get added as the Pivot table expands month by month when it is updated with new data.

As I add additional data to the information in the Value table - when the pivot table expands every month this data ends up on the wrong line - so that is why I create a Value table version of the pivot table in the first place and add this data in additional columns. So from Column A to K or AB depending on how much data I need, the Value table looks like the Pivot table, but then the is more data to the right of this.

Currently after I initially create the Value table, on a regular basis I manually go through each Value table row compare it to the Pivot table and insert the new row into the Value table as it appears. This way when I insert the row the additional data on the right of the basic pivot table data stays connected to the right row.

The macro should compare the row up to column K or AB in the value table and the new pivot table, and then if every cell is different in every column in that row in the value table to the pivot table (as this based on months – and some times the same data can have transactions in different months) and when it finds the new row in the Pivot table that isn’t in the Value table move all the data in the value table below it down one row and copy this new row into the Value table.
If I can’t work with a live Pivot table – could I do this with a Pivot table converted to a Value table?

Sorry if this isn’t clear – I will try and explain more clearly where it isn’t – if asked,

thanks

Peter - first post