6 Replies Latest reply: Feb 16, 2016 3:47 AM by Bill Markham RSS

    Track Changes in Table

    Phil Speight



      I have a pivot table which holds a total amount of hours by area.  Each day the data reloads and shows the most up to date data in the pivot.


      I want to show the change since yesterday, but as I have reloaded I have lost yesterdays data due to the reload.


      Is there any way I can create a column in the table that keeps yesterdays totals. 


      A bit like the example below .....


      Refreshed data held in column A

      Auto Copy and paste value (Column A) into new column B before reload

      reload data

      Refreshed value in Column A / Yesterdays value in Column B


      It might be a macro, but I have no idea.


      Any help appreciated?