Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
en:process_steps:range_cell:rangecopymove [2021/05/06 21:55] tiger |
en:process_steps:range_cell:rangecopymove [2024/02/24 14:43] (current) tiger |
||
|---|---|---|---|
| Line 4: | Line 4: | ||
| The basic process step to move data from one location to another is **Range Copy/Move To**. It works exactly the same as its manual version in Excel. You should first define (' | The basic process step to move data from one location to another is **Range Copy/Move To**. It works exactly the same as its manual version in Excel. You should first define (' | ||
| - | {{djeeni:rng_copy_move_to.png}} | + | {{ :en: |
| - | Note the use of a [[en: | + | The source range can be also specified by a [[en: |
| Then, you have to chose whether you want to copy or move the specified range. | Then, you have to chose whether you want to copy or move the specified range. | ||
| Line 15: | Line 15: | ||
| * you can choose what you want to copy/move: values, formats, formulas or all of them | * you can choose what you want to copy/move: values, formats, formulas or all of them | ||
| - | Range copy/move takes into account filters and hidden data - only visible, filtered data will be copied/ | + | Range copy/move takes into account filters and hidden data - only visible, filtered data will be copied/ |
| - | You filter the worksheet wsExample by a value in Column B. Row 4 and row 7 matches the filter criteria. Column C is hidden on wsExample. Then you copy the range wsExample!A1: | + | * You filter the worksheet wsExample by a value in Column B. Rows 4 and row 7 matches the filter criteria. |
| + | * Column C is hidden on wsExample. Then you copy the range wsExample!A1: | ||