How to copy the excel column formula to the newly added rows

I have multiple columns in excel file with formulas, when i’m using the Insert/delete row activity the columns formula is getting missed. Need help in getting those formulas to the new rows added.

4 Likes

Fine
we can use Read Cell Formula activity and get the formula written in the cell
–use excel application scope and pass the file path as input
–use this Read cell formula activity and mention the cell and sheetname as input while we will be getting the cell formula as output in string type
–this can be used in the new row we create later at any point of time

Hope this would help you
Cheers @Ramki81

1 Like

You need to create a recording, by first right clicking->Insert->copying the row and pasting with formula.
This may work if you have limited number of copy/pastes, I suppose.

Reading is fine, but how can i write it to newly added rows?

I have nearly 200 rows to insert.

@Ramki81, you just need to put formula in first row than use Autofill Range activity of excel, it will drop the formula till last row automatically. You no need to use loop.

Cheers!!

4 Likes

Thank you Vikas, it works.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.