Copy and paste old data formula in Excel

[venkateshtangudu (Venkatesh)]

Hi fnds,

How to copy and paste formula in Excel…
My new data is present A11:E11…so on
the formula is present in F10:Y10
how to drag the formula

[AshwinS2 (Ashwin S)]

Hi @venkateshtangudu

Use Excel application scope
Use select range
Use send hot key as Ctrl+c and
Use send hot key as Ctrl+v
Or
If you know the formula
Use write value activity and give the formula

Thanks
Ashwin.S
Ashwin.S

[venkateshtangudu (Venkatesh)]

hi,

my case is some what different…
every month i will get new data from A to F column(more than 1000 lines),i have more than 10 columns of formula G:H…should be pasted…from last month

[AshwinS2 (Ashwin S)]

Hi @venkateshtangudu

Then in that case set range as "A1:F+dttable.rows.count.ToString

And use write value activity

Thanks
Ashwin.S

[venkateshtangudu (Venkatesh)]

Hi Ashwin,

Can u plz help me with the code Book1.xlsx (13.0 KB)