How to copy columns from Excel sheet and past in new Excel sheet

(0) Share

Report

Posted on by bhavinrshah

Hello,

Kindly guide me in below task.

Book1: having 1 column values are below

Book2: having 1 column values are below

I want above both columns in New worksheet (i.e. Book3).

Then I have to Avg. of that both the columns and create a New Column with results.

1 10 > 5.5

2 10 > 6

Kindly help me .

Bhavin

Categories:

Using flows

I have the same question (0)

All responses (6)

Answers (1)

Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!

Hi

Yes i would love it please

thx

Was this reply helpful? Yes No
ahmadbutt 255 on at

Like (0)

Report
Copy link

Link copied!

Can you maybe post images of your solution? And if not can you tell me what sort of trigger did you used in the beginning?

Was this reply helpful? Yes No
Verified answer

bhavinrshah 39 on at

Like (0)

Report
Copy link

Link copied!

Hello @v-alzhan-msft

Below is the solution of how to copy column and past in different excel sheet.

Step 1: Create/Manage an existing sheet with a TABLE structure.
Step 2: Choose 'List rows present in a Sheet' - Choose a specific sheet.
Step 3: If you choose the right sheet then Table will be populated automatically.
Step 4: you need to start your looping on that specific column.
Step 5: 'Apply Each' you need to add 'Add a row into table'
Step 6: Run/Trigger your Flow.
Step 7: Once done you can see your column will be copy and paste in a new sheet.

Bhavin

Was this reply helpful? Yes No
v-alzhan-msft on at

Like (0)

Report
Copy link

Link copied!

Hi @bhavinrshah ,

Could you please share more details about your solution?

And if your problem has been solved,please go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
bhavinrshah 39 on at

Like (0)

Report
Copy link

Link copied!

Hello @v-alzhan-msft

Thanks for your Reply.

I have done with my task and find the solution which can copy multiple columns from different Excel sheet and past in Different sheet as a result.

Kindly let me know if you want any help in this direction.

Thanks
Bhavin Shah
Skype: bhavinshah50

Was this reply helpful? Yes No
v-alzhan-msft on at

Like (0)

Report
Copy link

Link copied!

Hi @bhavinrshah ,

Sorry for I'm afraid that there is no any easy way to achieve your requirement with microsoft flow.

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No