Use render tool to output to different workbooks and sheet names

[BA]

Hi Everyone,

I have produced a workflow which I need to split the output into different workbooks and tabs within the workbook.  Whilst I have figured out how to do this using the output data tool, I have to do this using the reporting render tool as the headers are coloured.   

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

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

Thanks in advance for your help. :)

[alexnajm]

I would create the full path beforehand with a Formula tool, and then use that to "Change Entire File Path" in the Render tool!

[binuacs · Accepted solution]

@BA one way of doing this