This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
My company has a system from which I can run reports at any given time. The data is raw and not easy to visualize so I am using Alteryx to automate the formatting. It's a report I may run several times a day and I want to keep all of the previous reports, preferably in a new worksheet in the same Excel file rather than a new Excel file each time. I would like the worksheets to show some kind of identifier like a date/time stamp.
For example, the first time I run the macro, it would generate "REPORT.xlsx" with one worksheet called "2018-12-16 2048" (say for 10:48 PM). The second time I run the macro using more current data from my company's system, it will add a new worksheet in the same Excel file "REPORT.xlsx", called "2018-12-17 0930" (say for 9:30 AM).
I'm very new to this so I don't even know if it's possible, but did a lot of searching online and couldn't find anything so far.