Skip to main content
Version: Streamsheets 2.5

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

NameDescription
SourceRangeSource Range to retrieve data from
TargetRangeTarget 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

FormulaResultComment
=COPYVALUES(A2:B2,A4:B4) 
TRUE
danger

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