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

    Track Changes in Table

    Phil Speight

      Hi

       

      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?

       

       

      Thanks

       

       

      Phil