For you to copy over formulas in excel here are many workarounds and solutions through code, activities and hot keys are suggested. check the following links.
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…
I think there is a problem in your formula.
[image]
Using write cell you can set the value to a valid formula.
Hello folks,
My requirement is to generate the Excel report every day. My doubt is once the execution is finished the excel row counter will back to its default value. If execution starts again on tommorow how does it know it should write the cell value in A4 or A5 etc. Could some suggest on the same
Hope this helps
1 Like
prashant1603765
yedukondaluaregala
sharazkm32
ashokkarale
sonaliaggarwal47
Rahul_Rajendran
V_Roboto_V
revathi3
juan_haro
goag2413