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

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).

Data to be copied.JPG Paste Data Here.JPG

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

Thanks in advance for any help!

Matt

Workflow

Accepted answers

MichalM

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.

All comments

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15874

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703