Range Copy/Move To

The basic process step to move data from one location to another is Range Copy/Move. It works exactly the same as its manual version in Excel. You should first define ('select') the source range and then specify the top-left cell of the target range:

  Range Copy/Move    Source range=wsExample!A3:C6  Target top-left cell=wsTarget!B4
  Range Copy/Move    Source range=rgExample  Target top-left cell=wsTarget!B4

Note the use of a named range in the second example.

You have the same options as in Excel:

• 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

Your last choice is if you want to copy or move your range.

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. Row 4 and row 7 matches the filter criteria. Column C is hidden on wsExample. Then you copy the range wsExample!A1:D7 to another location. Only the two filtered rows (4 and 7) and the 3 visible columns (A, B, D) will be copied.