Hello,
I have multiple workbooks, in 1 common directory. Each workbook has 1 worksheet named "Test_Data".
My goal is to merge all these worksheets into one final output Excel workbook.
I tried to use a Dynamic Input Tool, but I can't seem to work with it.
Can somebody help me with this?
Thank you in advance.
Solved! Go to Solution.
Hi @beatrizmguerreiro this post might be helpful for you and has example workflow.