Output Data to make multiple worksheets in one excel workbook

I have attached a sample data that I have made to mimic my data.

What I have is a workflow that filters my data based on different criteria and I want to then create an excel workbook with a different worksheet that is named in the formula with the date and time that it is ran for each filter. I want to include the date and time in it because I will be running this workflow multiple times and want to see when it was ran easily.

I am not getting any errors when running my workflow but it is also not creating my excel workbook

Any help would be appreciated with this. Please let me know if there are any questions

Sample Data.yxmd

Output

Custom Tools

Date Time

Accepted answers

ConnorK

Hi @Travis_Ratliff ,

For this I would try changing the whole "File / TableName" with the Sheet Name + DateTime value for each new sheet. Please see the workflow posted below. Please note that you will need to change the location that the outputs save to once you save the workflow on your machine.

Best,

Sample Data.yxmd

All comments

ConnorK

Hi @Travis_Ratliff ,

Best,

Sample Data.yxmd

Travis_Ratliff

This got the workflow to create the spreadsheets which I appreciate. However, can I make them into two different sheets in the same excel workbook?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703