I currently have a workflow that creates an Excel worksheet that has multiple tabs in it. The worksheet and tabs are for asset custodians. So the asset custodian could change from year and the number of tabs could change as well. I am looking for a way to export each individual tab to a separate Excel worksheet. This will allow me to email them to the custodians for review. I saw a couple of workflow questions about this one was a work sheet with Austria and other countries but think that was not what I want to do.
@jfrink1
Get your original workflow to create also the individual file for each custodian.
Hey @jfrink1 I think you can use a custodian field to create multiple excels. Check out this video - https://www.youtube.com/watch?v=XXwMJHqK1PM
Hope this helps.
This video is for creating a CSV file. I want to export my data to multiple excel files. Do not want user to have to convert CSV file to Excel to many worksheets will be created
Hey @jfrink1 I think you can change the file type from CSV to Excel when you are exporting the data. That shouldn't be a big issue. Let me know if you are able to do that.
User | Count |
---|---|
63 | |
25 | |
23 | |
21 | |
20 |