Paste formula -range is not fixed

Help
1

Hi ,

I have certain data in a datatable . I want to paste those data into the Excel sheet and apply formulas to the newly added data.

Example:
Assume I have data from column A to E in a Datatble. Now am using write range with the help of row count am writing data.
Next from column F to K columns–>each row has formula ,iNow copy formula from E1 using copy formula activity

Now how to apply those formulas against newly added data ?? and also row number should change dynamically
@Palaniyappan

2

Hi,

What I will do is to write range the data first and then use VBA macro to insert formulas for every row from Col F to Col K.