Create new excel file then append new sheet

Question

Hi

I am currenly working on a set of payroll data where there are several employees' info in it.

These are what I would like to achieve in the output:-

1. Output as separate files based on the employees' names

2. Append a tab named "Total" to the newly generated files, showing the summary of each income item according to the employees' names

I have worked out the 1st step, but have no idea on how to append the new tab to the separate files. Desired output will be something like this:-

Can anyone please help? Please see the attached workflow where I am done halfway.

Pay (sample).yxmd

JosephSerpis · Accepted Answer

Hi @ZiXi08  you are nearly there you just needed to add another formula tool to append the Total tab in your excel files and change your output to overwrite sheet. I've attached the workflow.