import multiple table data set into multiple sheet in existing excel file

troy_mech

I have created three tables in alteryx and need to paste those table values in standard excel template. Each tables need to be pasted in specific sheet and specific cell (example A14) but this should not depended with cell range. Could anyone please help me on this

morr-co

Would it be possible to calculate the range end in your workflow? For example, if you use a Count Records tool you could add that value to 14 to get the ending row. You could then determine the column based on the number of columns in the output. Using that value, you could dynamically update the range-end value using a macro similar to the mock up below.