Answered

Copy & Paste on next blank row

(0) Share

Report

Posted on by Wez1

Hello guys

I'm struggling to fix a flow that would allow me to Copy data from one Excel file to another, but to look for the next free row

Currently it goes like this:

Launch Data file

Get first free column/row from excel worksheet

Select the cells in excel worksheet

Copy Cells

Launch Other file

Get first free column/row from excel worksheet < This is where I'm going wrong?

Paste Cells on currently active cell

Close Excel

It never finds the next cell or it goes down to row 5000 and pastes it there

Any help would be appreciated , thank you

Categories:

Power Automate Desktop

I have the same question (0)

All responses (15)

Answers (1)

Sort by

Wez1 37 on at

Like
a
(0)

Report
Copy link

Link copied!

Managed to fix it - there were hidden formulas on some of the rows

Was this reply helpful? Yes No
Wez1 37 on at

Like
a
(0)

Report
Copy link

Link copied!

Evening all

Been a while since I visited and continued on with this

I'm very much stuck on this - I thought I figured it out

Does anyone please have a flow which they can share to allow me to copy from one worksheet to another (into the next free row)

Thanks

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Can you share a screenshot of your own flow, so we can point to what you are doing wrong? It seems like you might either be using the %FirstFreeRow% variable incorrectly, or pasting to an active cell without realling activating the correct cell. If you use Paste cells to Excel worksheet and set it to paste to the currently active cell, you must first use Activate cell in Excel worksheet to set which cell is actually active. And use the %FirstFreeRow% variable in there to activate the cell in the first free row.

-------------------------------------------------------------------------
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.

Was this reply helpful? Yes No
Wez1 37 on at

Like
a
(0)

Report
Copy link

Link copied!

Morning Agnius

So the first launch excel is opening the raw data, then copy and pasting into the reporting file

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

As expected, you are missing the Activate cell in Excel worksheet action to activate the cell in the first free row of your target Excel file. Please add that after step 7 to activate cell at row %FirstFreeRow2% and column A in %ExcelInstance2%. Then you should get your data pasted correctly.

-------------------------------------------------------------------------
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.

Was this reply helpful? Yes No
Wez1 37 on at

Like
a
(0)

Report
Copy link

Link copied!

Which one is it from the drop downs please?

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

It's the "Absolutely specified cell", so you can provide the row index and the column name.

-------------------------------------------------------------------------
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.

Was this reply helpful? Yes No
Wez1 37 on at

Like
a
(0)

Report
Copy link

Link copied!

I used absolutely specified cell and it pasted it here

Column V - AC are formulas - do you know how to get them to paste below A - U

Was this reply helpful? Yes No
Wez1 37 on at

Like
a
(0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Instead of using Get first free column/row from Excel worksheet on your target Excel file, use Get first free row on column from Excel worksheet and make it get the first free row on column A. This will ignore the fact that you have content in columns AD and others and will get you the first empty row on column A. Then use that when pasting your data.

-------------------------------------------------------------------------
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.

Was this reply helpful? Yes No