Search

Copy Entire Data as Table

Articles

Use this function to copy the values and metadata from the given input range and provide output according to the input Table Definition.

Syntax

Copy Entire Data as Table (table_definition, range)

Parameters

Input Parameter Name Description
table_definition Name of the table from table definition to which data will be copied
range First cell to last cell value separated by : to copy the values

Returns

Return value Description
Table Returns the copied data as a table

Sample

Copy Entire Data as Table (FourColstable, C3:F8)

  • Copies values from cell C3 up to cell F8 to table FourColstable.

To view all the Excel functions, click here.

Did you find what you were looking for?