Splitting a spreadsheet to multiple Excel workbooks and tabs by column names

[BA]

Hi Team,

I have a spreadsheet which I want to split using column names and save as different workbooks but also different tabs within the workbooks.

Period	Project	Description	Filename
May	Xerox	blah blah	A
June	Blue	blah blah	B
Sep	Fuller	blah blah	C
Jan	Canterbury	blah blah	A
Sep	Solar	blah blah	B
Sep	Canterbury	blah blah	A

So in the above instance I would want to split Filename into different workbooks and have Project split into tabs within the corresponding workbook.

Hope this makes sense. Happy to provide more information.

[Clifford_Coon]

Hi @BA ,

You can insert the full path or file name as a field.  Shown below B / Blue.  Separate  tab w

[FullPAth}\B.xlsx|||Blur

[binuacs]

@BA Sample workflow attached 

[Nezrin]

Use formula to create a dynamic file path and Specify the column on the output tool

[BA]

Thanks so much for this, this is the closest to what I am looking for.  I did change the filename to be the project name so it saves as in different files and corresponding tabs.

I am getting an error message though:

Error: Output Data (46): Internal Error: STD Exception in thread: boost::filesystem::status: Access is denied: "[file path of some sort]...."

Not sure how to workaround that.