2 Replies Latest reply on Feb 20, 2012 9:39 AM by Fabio Annovazzi

    Dynamically hide yesterday's column every day?

    Fabio Annovazzi

      Hi,

       

      I have a workbook (attached) that every day is updated with new data about number of fans on facebook pages. I list the pages with the greatest increase in fans in this last week relative to the previous 30 days. The pages are sorted by this criteria. Basically I show the last column (last day). Every day I need to hide the data of the day before. The workbook has some table calculations, so it takes some time to update. I would be great if I could simply update the data, and it would hide all the columns except the most recent by itself. Is this possible?

       

      Also, is there something I need to do to make it load faster?

       

      Thanks

       

      fabio