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:
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:
Comments
0 comments
Please sign in to leave a comment.