Unanswered

Copying excel row table data from one excel to anther excel sheet

(1) Share

Report

Posted on by Mahipundir

Dear all,

I am wondering if someone has done it and can share their knowledge. ?

I'm trying to copy excel row data from one excel sheet1 to excel sheet2 once a column changes the status in excel sheet1, I have done it with macros in past locally and now trying to achieve this via the power automate.

I can create and update rows using power automate excel online action but can't see a way to copy/cut to excel sheet2

I hope this time I will get answer from power automate community.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

ChristianAbata 8,951 Most Valuable Professional on at

Like (1)

Report

hi @Mahipundir I think you can use Run Script

Solved: Excel (Business) Email Cell Value Not In a Table - Power Platform Community (microsoft.com)

Was this reply helpful? Yes No
mathiaskjeldsen 224 on at

Like (0)

Report

Hey

Should be doable. You need to implement a variable logic that captures the change, but from there you can use the send keys actions to send ALT E + M, to get the copy worksheet window up. Then from there send a few more keys to click create copy and choose the new workbook. If you don't know how to use Send Keys functions and work with Excel using Power Automate, I covered it in this video: https://youtu.be/qdcUYE3swxU

Let me know if you still got issues.

Best regards

Mathias Kjeldsen

---

If this has helped solve your problem, please mark it as Solution.

Connect with me on social platforms by using the links below.

YouTube: https://www.youtube.com/@matkjeldsen
LinkedIn: https://www.linkedin.com/in/mathiaskjeldsen/

Was this reply helpful? Yes No