how do I copy an excel sheet as a excel tab in generated output

Question

I have an excel file that contains 5 tabs in which 3 tabs have to be modified and other 2 should me same as input.

I am done with the modification part now I am stuck with how to generate the output that will contain all 3 modified tabs and 2 original tabs as input. Can someone help me with that

echuong1 · Accepted Answer

You can set your output to be the same as the original file. The three modified tabs would take place with three separate output data tools. With the update, make sure the setting is to overwrite sheet, and not overwrite file.

The unmodified tabs should remain the same.