COPYVALUES
Copies the values from the given source range to the target range. Beware that only the values are copied and not formulas. If the target range is a multiple of the source range, the target range is filled repeatedly with the source values.
Syntax
=COPYVALUES(SourceRange, TargetRange)
Arguments
| Name | Description |
|---|---|
| SourceRange | Source Range to retrieve data from |
| TargetRange | Target Range to copy values to. If Range smaller or bigger as Source Range values will be added accordingly (less input or multiple input). |
Return
TRUE, if successful.
Examples
| Formula | Result | Comment |
|---|---|---|
| TRUE |  |
danger
Only the values will be moved. Formulas will be removed.