copy paste from another excel file

Question

Hi All,

Can you please guide me on a question that I have on a workflow that I am trying to build. I have a excel based template which has some formulas. Now, in this template(Input file) I want to paste some columns from another excel file.

I wanted to understand how can I do this.

Thanks

atcodedog05 · Answer

@mihir_mir_jb wrote:@atcodedog05 thank you for your reply.

I have attached two files book1 and book2. Book1 is the template file which I want to keep as Input file where column A to G are formlua driven cells which will be poulated basis the data that I paste in columns H through W from Book 2.

Hi @mihir_mir_jb

Here is an example. Book2 as new data and Book1 is the template file.

Workflow:

1. I am reading input data from Book2.

2. I am writing data to Book1 (template file) from column H1. The range needs to be set in Ouput tool writing to Book1. Output option should be set as overwrite sheet.

If you follow the above config it should work.

Hope this helps 🙂

Book1.xlsx

Book2.xlsx

copy paste.yxmd

atcodedog05 · Answer

Hi @mihir_mir_jb

Yes thats right select the sheet in which you want to overwrite and add these columns should work.

mihir_mir_jb · Answer

When I input the tempalte file at that time also I get this option of 'Select Excel Input, there as well do I need to select only that particular tab as the template file also has various tabs