Copy Paste

overview https //docs procesio com/write to file#yja0t use this action to copy and paste a cell range from source to destination within the same workbook workbook to other workbook how to configure the copy paste action? https //kb procesio com/regex replace#qd how to https //docs procesio com/merge lists#q how to https //docs procesio com/write to file# s0vi step 1 create a process and give it a name step 2 drag the copy paste action to the canvas and link it to the other actions step 3 create the variables needed for the configuration of the action, and then add them to the configuration panel source workbook you need to input the file with the workbook where to copy from source sheet you need to input a string with the sheet name where to copy from destination workbook you need to input the file with the workbook where the cell will be copied destination sheet you need to input a string with the sheet name where the cell will be copied range you need to input a string with the range of cells to copy and paste (\[col]\[row] \[col]\[row] format (excel style)) keep selector dropdown with all/style/values/formulas options using keep, the user will choose which characteristics to keep when pasting paste starting from you need to input a string with the cell where pasting should start from in the destination sheet represents the cell where pasting should begin (range shape is maintained) notes this version does not support style transfer when copy pasting to a different file (so source and destination should be the same workbook) step 4 save , validate and run the process step 5 you will be prompted to add the file for our input variables click run step 6 to verify the process click check instance step 7 download the destination file with the xls content as defined in the action