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 ('select') the source range and then specify the top-left cell of the target range:
The source range can be also specified by a named range.
Then, you have to chose whether you want to copy or move the specified range.
The last two options are the same as in Excel:
Range copy/move takes into account filters and hidden data - only visible, filtered data will be copied/moved. For example: