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 [2020/03/05 16:39] andraz |
en:process_steps:range_cell:rangecopymove [2024/02/24 14:43] (current) tiger |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | {{indexmenu_n> | ||
| ====== Range Copy/Move To ====== | ====== Range Copy/Move To ====== | ||
| 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: |
| - | < | + | The source |
| - | Range Copy/ | + | |
| - | Range Copy/ | + | |
| - | </ | + | |
| - | Note the use of a [[en: | + | Then, you have to chose whether you want to copy or move the specified |
| - | You have the same options | + | The last two options are the same as in Excel: |
| * you can overwrite the target range or insert you source range above or left to it; and | * you can overwrite the target range or insert you source range above or left to it; and | ||
| - | * you can choose what you want to copy: values, formats, formulas or all of them | + | * you can choose what you want to copy/move: values, formats, formulas or all of them |
| - | Your last choice is if you want to copy or move your range. | + | Range copy/move takes into account filters and hidden data - only visible, filtered data will be copied/ |
| - | Range copy respects filters and hidden data: only visible, filtered data will be copied. Example: | + | * 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: | ||