cross tab data to be published in Excel file

[troy_mech]

Hi, I'm new in Alteryx tool and looking for paste the cross tab result into existing excel file in the specific cell range. I have made 3 cross tab results and want to paste in each sheets in existing file. I have tried Output tool option with "existing sheet option", but no luck. Even I tried the "amend and delete" option this was not worked due to dynamic range output from Cross tab tool. So this would be more helpful if anyone will come with a solution.

[PeterA1 · Accepted solution]

Hi @troy_mech  You have a couple options: 

1. Output to a named range,

This can be done to a dynamic named range by creating a "table" in excel, then having a named range be == to that table, so when the table expands so does the named range

2. Outputting to a specific range of cells (e.g : A:C or A1:B1")

The second option can be done so that you overshoot the amount so "A:BB" to make sure all data can fit in the range.