How to Copy from one file and paste into another file to a specific cell

[Matt_Hancock]

Hi,

First time posting so I apologize for any errors.

I have a workflow that creates 26 excel files, each looking the same but based off a different distribution center.  I need to create a workflow that will take one of the files, copy it, and paste it into a specific cell of another excel file that has preloaded formulas the data will run against. Currently, I have to run this process outside of Alteryx and then go back to Alteryx.

Here's an example of the data I need to copy (image 1). I need to start the copy on cell A2 and copy over to the right and down.  Then I need to paste it in the other file beginning in cell A2 (image 2).

I'm trying to figure out which tool(s) can help me do this.  Any thoughts?

Thanks in advance for any help!

Matt

[MichalM]

@Matt_Hancock 

Alteryx is capable of outputting into a specified range within Excel - see an example here. What you need to keep in mind though is that the content of these cells will be overwritten resulting in your formulas to be cleared. There are two options.

1. Outputting into a raw data sheet (which can be hidden) and mapping these to the active formula sheet

2. Rebuilding the formulas in Alteryx and outputting just the result.

Personally, I'd lean towards the latter.

[Matt_Hancock]

Thanks for the quick reply!

The formulas I have written in the file being pasted to do not begin until the column just past the data being pasted.  Will Alteryx only paste over the exact area the copied data covers, or will Alteryx replace all data on the tab I am pasting to?

Thanks,

Matt

[MichalM · Accepted solution]

In which case you should be safe. Alteryx will only overwrite content in the specified range. 

Make sure you use the Overwrite Sheet (Drop) option when configuring the output.

[Matt_Hancock]

That worked!  Thanks for all the help!

[mweisba1]

What if I have a 100+ sheets to copy and it's different for each sheet? I'm guessing I would have to map sheet to sheet and then the starting cell to copy into.