Range Copy/Move

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.