Hi All,
I created two tables (one for data that needs to be entered, one for data that has duplicates) from a large excel file and I want to save them into the same excel file, but in two different sheets. I tried using the layout tool but I would end up with the two tables in the same sheet.
Any suggestions?
Solved! Go to Solution.
Hi @JMill
Is there a specific reason you need to use the Render tool? You can accomplish the same thing using the Output tools:
Point both outputs to the same Excel file, remembering to change the Sheet name, and change the Output Option to 'Overwrite Sheet or Range'. I'd stick a 'Block Until Done' tool in as per the example so that each section of the workflow finishes before the next runs so you don't get errors with Excel still being open.
I've attached a sample workflow for you to look at.
David
This worked great! Thank you for your help