Copy specific ranges to existing file

[Phalanx1]

Hi all,

I want to copy a specific range from an existing excel file (B5:F5) to another existing file (J5:N5).

How can I go about this?

I appreciate any help!

Thanks

[grossal]

Hi @Phalanx1,

the current version (2020.1) let's you select an Input Range and also an Output Range. Make sure to select "Overwrite Sheet or Range" in the Output Panel.

Input:

Output:

Best

Alex

[Phalanx1]

Hi Grossal,

this unfortunately does not solve my problem, since I can not attach my data to the desired sheet. The error message says that a sheet has to be existent. I dont understand this because there is "Sheet1" in which I want to copy the source data into.

[Phalanx1]

When I select to overwrite, a new sheet gets created which I do not desire to do...

[grossal · Accepted solution]

Please make sure to Select "Overwrite Sheet or Range" and not "Overwrite File (Remove)".

Are you able to share your workflow/sample data?

[Phalanx1]

Hi, I deleted all old data and tried all over again and it worked.

Thank you!

[bharat_nimmagadda]

I have a similar requirement but my input is dynamic, so how do i select a range using Dynamic Input and pass it to Output