How to copy formulas of K2 and K3 cell and paste to last row below

Help Studio
, ,
1

I want to copy formulas of K2= -J2/J3 and K3= K2
and paste it to all the cell below down.

The image depicts a workflow automation sequence involving reading data from an Excel file's Sheet2 and performing a division operation to write the result in cell K2 of the same sheet. (Captioned by AI)
The image depicts a workflow automation sequence involving reading data from an Excel file's Sheet2 and performing a division operation to write the result in cell K2 of the same sheet. (Captioned by AI)687×790 28.8 KB

The image depicts a sequence of automation tasks for updating Excel spreadsheet cells, including writing formulas and copying a range of values from one location to another. (Captioned by AI)
The image depicts a sequence of automation tasks for updating Excel spreadsheet cells, including writing formulas and copying a range of values from one location to another. (Captioned by AI)603×727 23.9 KB

A spreadsheet column labeled "FD AI" shows a series of numeric values, both positive and negative, with an adjacent column titled "%" in a blue-highlighted section. (Captioned by AI)
A spreadsheet column labeled "FD AI" shows a series of numeric values, both positive and negative, with an adjacent column titled "%" in a blue-highlighted section. (Captioned by AI)288×634 6.59 KB

fillRowFormula.xlsx (51.5 KB)

2

@Syed_Sultan_Ahmed1,

Use Auto Fill activity to fill the formula to all the rows below.

Your source range would be K2

3

@Syed_Sultan_Ahmed1

use auto fill range but your source range would be Excel.Sheet("Sheet2").Range(K2:K3)

cheers

4

Hi , I tried it but its just filling K2 and K3 cell after that its just copying K2 formula and pasting into another cell till bottom, it has to copy both diffrernt formula and paste it

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.