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 Value

TRUE, if successful.

Example

Function

Result

=COPYVALUES(A2:B2,A4:B4)

COPYVALUES1


COPYVALUES2

Warning

Only the values will be moved. Formulas will be removed.