Paste same data in every sheets in an excel file

[avisingh96]

Hi Community,

I am working on a file and I have a set of rows that needs to be stacked below the rows of every sheets in the file. All sheets have same no. of columns and fields, just the data inside those fields may be different. 

To be precise, I just want 3 rpws to be stacked below the existing data in all the sheets altogether when I copy that data in one sheet.

P.S. - The data to be copied will be same across all the sheets.

I am not sure how to use Macro and Control parameter. Please help

[mceleavey]

Hi @avisingh96 ,

you need to configure your output tool with the following:

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/Getting-Started-with-Batch-...

https://help.alteryx.com/20231/designer/control-parameter-tool#:~:text=A%20Control%20Parameter%20is%....

I hope this helps,

M.

[avisingh96]

Hi @mceleavey

With the following?

I think you have not replied completely.

I am not sure what you meant. 

[mceleavey]

Hmmm, not sure why it won't allow screenshots...