Copy cells formula is one of the many instructions that can be used in a "Multiple file manipulations" action step. You can use it to copy a formula from one range to another range in an Excel workbook.
In your "Multiple file manipulations" action step, select the Copy cell formulas instruction via Microsoft Excel > Copy > Copy cell formulas.
2. Select your source file, worksheet and cell range.
Note: If there does not exist any formulas in your cell range, you will be presented with the following error.
3. Select your target file, worksheet and cell range.
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: