Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
en:process_steps:range_cell:rangecopymove [2020/02/28 16:13] tiger created |
en:process_steps:range_cell:rangecopymove [2024/02/24 14:43] (current) tiger |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== Range Copy/Move ====== | + | {{indexmenu_n> |
| + | ====== Range Copy/ | ||
| - | The basic process step to move data from one location to another is **Range Copy/ | + | The basic process step to move data from one location to another is **Range Copy/ |
| - | < | + | {{ :en: |
| - | Range Copy/ | + | |
| - | Range Copy/ | + | |
| - | </ | + | |
| - | Note the use of a [[en: | + | The source range can be also specified by a [[en: |
| - | You have the same options as in Excel: | + | Then, you have to chose whether you want to copy or move the specified range. |
| + | |||
| + | The last two options | ||
| * 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 |
| + | |||
| + | Range copy/move takes into account filters and hidden data - only visible, filtered data will be copied/ | ||
| - | Your last choice | + | * 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: | ||