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 batch macro that I am wanting to write in to my workflow that will loop through a specific site listing, update a filter within the macro, and then should output the data on to a table/range within an .xlsm file.
Configuration of XLSM (output tool)
Configuration of batch macro
Ideally, the output should look something like this:
But instead it looks like this:
The batch macro loops through each file successfully, but it looks like it is not overlaying the data on to the xlsm before creating the output. Any help would be greatly appreciated! 😀
What I would like for the workflow to do is take the data that is filtered out through the batch macro, and then essentially copy/paste (for lack of better terms) it in to the xlsm, then save the xlsm as a specific file name. Each site will have its own file they will be working off of.
I have attached the original workflow that I am building. For ease, it will be the last sub-container on the upper right-hand side. It is entitled "SITE ITERATION MACRO".
Edit: Attached picture of container that I am referring to.
By changing the file name you are creating a brand new file with no formatting to keep. It sounds like what you need is a template file with your formatting that can be used to output any number of files for each site. Here's two approaches: