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
Solved! Go to Solution.
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.
Thanks