Skip to main content

Copy cell formulae

Cameron Duncan
  • Updated

Copy cells formula is one of the many instructions that can be used in a "Manipulate Data" action step. You can use it to copy a formula from one range to another range in an Excel workbook.

In your "Manipulate data" action step, select the Copy cell formulae instruction:

 

Copy_Cell_Formulae.png

2. Select your source file, worksheet and cell range. 

Copy_Cell_Formulae_2.png

Note: If there does not exist any formulas in your cell range, you will be presented with the following error.

Copy_Cell_Formulae_3.png

3. Select your target file, worksheet and cell range.

Copy_Cell_Formulae_4.png

4. Save and run the instruction. Once completed succesfully, your formulas will be applied to your target range.

Tips and tricks:

You can configure the Copy cell formulas instruction to either copy or ignore the format of the source cells by checking or unchecking the following box:

Copy_Cell_Formulae_5.png

Comments

0 comments

Please sign in to leave a comment.