Hello Everyone-
Is there a way i can report out hourly numbers for a day within a new excel workbook for ever day ? meaning for today's date i should get an excel workbook with 24 worksheets (at 11:59 pm) for each hour starting from midnight and then for tomorrow the workbook should start with tomorrow's hourly data after midnight.
Thank you very much.
Solved! Go to Solution.
Can you post sample data?
Hello @mborriero-
Thank you very much for the code. I however don't see a Test.xlsx file output to my local machine, wasn't it suppose to do that ? please advise.
Thank you.
Thank you @mborriero-
I changed the path in the Output tool however I didn't changed the file path under the Formula tool which was the reason the program was dumping the test.xlsx file under the Downloads folder instead of the required folder.
Yes, this is exactly what i was looking for .
Thank you very much for helping.