Copy and Paste excel tabs from a Master Source file to multiple files

[jaypdejesus]

Hi,

I am looking to use Alteryx to copy and paste tabs from a Source file to multiple excel files. The tab names are the same across the Source file to the output files. The Source file contains some cells that are merged together, so the goal would be to preserve formatting. Attached is the source file that i would like to copy and paste to the output files.

From an excel perspective, here are the steps i would like to do and repeat.

1. right click on a sheet in the Source file

2. Select "Move or Copy"

3. Select the destination file

4. Click Create a Copy

5. Click OK

[apathetichell]

input template file as path to blob input tool. append to list of the new filenames. use blob output tool to output new files.