Here’s the scenario:
Currently, my automation writes two different excel files - basically two different tables - everytime it runs. However, I need both the files to be in the same workbook as two different sheets. The first one being “Sheet1” and the second one being “Sheet2”.
Is there anyway of achieving that?
I am aware of the “Append Range” activity, but the content from the second table would be pasted right below the first one - and that’s not what I want.