16 Replies Latest reply: Feb 16, 2017 8:25 AM by Adam Davies RSS

    Loop Through Sheets and Dates

    Alan Farrell

      Hi,

       

      I have a file that loops through each sheet every 15 seconds, the dataset is nothuge sheets change every 15 seconds without any issues.

       

      I have no user interaction and I always have 3 days of information.

       

      So I need to loop through each sheet for each date

       

      So example

       

      Sheet 1 15/02/2017 15 seconds later......

      Sheet 2 15/02/2017 15 seconds later.....

      Sheet 3 16/02/2017 15 seconds later.....

      Sheet 1 17/02/2017 15 seconds later.....

      Sheet 2 17/02/2017 15 seconds later.....

      Sheet 3 17/02/2017 15 seconds later.....

      Sheet 1 18/02/2017 15 seconds later.....

      Sheet 2 18/02/2017 15 seconds later.....

      Sheet 3 18/02/2017 15 seconds later.....


      Again, I am currently looping through the sheets, but I am not looping through the dates as I want.

       

      I tried using sheet triggers on leave by adding a select in field of the date, but that does not work

       

      Hope you can help.

       

      Regards

       

      Alan