Copying the formula in excel and pasting it till end of the sheet

Help Studio
, ,
1

Hi
Actually I have 8 columns containing the formula and I need to drag them all till the last.
So how it can be done
8 columns contains 8 different formulas.
But I want to do it without using UI interaction or sending the hot key .
I have tried using Auto fill range also but that is also giving some error.

2

Hi @Kunal_Jain

Have you tried Copy Patse Range Activity?

Try this, hoping your issue will resolve

3

@Kunal_Jain

Can you tell what error it is?

alternately can read the formula and then create a datatable with formulas and write that directly

Hope this helps

cheers