Creates a new column named TEMP containing the values in column one of the current spreadsheet.
|
Creates three new columns named TEMP, VX, and VY, containing the values in columns 1-3 of the Sheet2 spreadsheet.
|
TEMP = DATALINK(Sheet4, C5R10) or TEMP = DATALINK(Sheet4, R10C5)
Creates a new column named TEMP containing the cell value in the 5th column, 10th row of the Sheet4 spreadsheet.
|
TEMP = DATALINK(Sheet1, C1R1:C3R500) or TEMP = DATALINK(Sheet1, R1C1:R500C3)
Creates three new columns named TEMP, VX, and VY, containing the values in rows 1-500 of columns 1-3 of the Sheet2 spreadsheet.
|
Copyright IBM Corporation 2012. All Rights Reserved.
|