Add big forumla in write cell

[Soudios (Sou)]

I need to copy this formula from excel 1 and past it in Excel 2

Formule - Copie.xlsx (10.5 KB)

[wasea (Vasile)]

Hello @Soudios ,

There are some posts in this forum regarding this. Did you checked them?

Problem when copying formula in excel cell

I am copying a formula of logic type in excel to bring values ​​from one sheet to another with uipath. When applying the formula manually it works well for me, however when I use automation it generates the following error: [image]

Copy formula from one excel to another

Hi there, I’m trying to copy a range of formula from one excel to another using Read Range on the first excel and Append Range onto the second excel. The outcome was the write range seem to write the value rather than the formula. I cannot use “Read Cell Formula” because i needed to fill-in a Data Table into the Append Range instead of just values.Below are the excel and xaml files that i’m currently using. formula_from.xlsx (10.8 KB) formula_to.xlsx (10.5 KB) Copy & Paste Formula.xaml (8.2 …

Copy and paste formulas

I want to copy a formula to a range of cells. The range of cells changes with each iteration of the robot by copying a row and insert copied cells. I have a defined name for the cell that I want to ctrl-c and a named range that moves with the insert. My problem is I haven’t found a way to get the robot to make either name “current”. I don’t find a select range, goto range or similar. Maybe I need to go through the menus to use goto? sort of answering my own question but it would sure mak…

Excel automation using formulas

[formula in excel]

I hope it helps.

Vasile.

[Soudios (Sou)]

HI @wasea

Thank you for your reply.

i tried but it doesn’t work for me, can you check my file plz ?

[prasath17 (Guru)]

@Soudios - Have you tried copy paste range, by choosing “Formulas” in the properties panel?

[Soudios (Sou)]

@prasath17

I can’t change it, i have uipath version 2019.10.6