Hi so I have been using input data, select, and output data to automate the retrieval of data from some excel files on excel and pasting it into other excel files. This worked fine until the initial files may be different each month which means I would manually have to change the specific cell range on everything. Is there a way to tell apteryx to grab all cells in specific columns without specifying the exact cell range? Thanks!
For example if you had excel files with a chart and you wanted to relocate that to another file. No manipulation. I just want to replicate if I were to CTRL+C one file and CTRL+P on another file. But the output data tool needs you to select an exact cell range that matches the input data range. I want to output or "copy paste" even if the input is larger or smaller without changing of my ranges. Thanks.
User | Count |
---|---|
106 | |
82 | |
70 | |
54 | |
40 |