42
Hi team,
My scenario is like this
I am having a single worksheet . I want to copy range from row 6 to row 16 , then I have to insert rows in between rows 17 to 18 and next I need to paste those copied range inside the inserted rows (between rows 17 and 18). I am able to copy and paste rage in last rows but not able to do in between rows. Anyways to do so????
You will need to use Insert row to Excel worksheet first to insert the new rows. Since this action can only insert one row at a time, you will need to put it in a loop to insert as many rows as you need. You can use a Loop action iterating from 6 to 16 (or from 0 to 9) and incrementing by 1.
Once you have done that, you can use Pase cells to Excel worksheet to paste what you have copied to row 17 (which is now blank after making the inserts).
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.
I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.
Share
Report
All responses (
Answers (
