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.
I have a workflow that runs once a month and uses the month/year to dynamically name the exported excel file. The exported file contains data for multiple offices. I have a request to add to this file an individual sheet for each office. I would like to do this all in one workflow instead of having to run 2 workflows or use an excel macro to cutup the data.
I have no problem dynamically naming the file using the month/year but I'm unsure how to use this master sheet and create separate tabs for each office. I don't see an option to create a file based on 2 dynamic fields. I've tried to use a block until done to save the file then access it again but I am getting errors.
I think what you're looking for is a batch macro. In the workflow you already have, output to the master sheet as normal. Then feed in the data that makes up the file to the batch macro input, and a unique list of the offices as the control parameter. The macro will dynamically create sheets based on the Office name.
I've attached the example here. Let me know if you have questions!
Hi @laneytrax if you use a formula tool you can use the Month/Year field or Fields to create the file name and then use the Office data to spilt the data into different sheets. This will then create the file plus also spilt your data into different sheet i've attached an example.