![]() |
![]() |
|
![]() |
![]() |
|
![]() |
![]() |
![]() |
Description: Returns the value from the specified cell in the selected data source. Use numbers to identify both the row and column (e.g., for cell A2 in the data sheet, enter 2 for the row and 1 for the column).
Syntax: DATAENTRY(Data_Src, Row, Column)
Data_Src is the source data sheet from which the value is taken.
Row is the row number in the data sheet.
Column is the column number in the data sheet.
Remarks:
The Data_Src can be one of the following values:
A default data source selected from the Data Source Index drop-down list.
A data sheet name (e.g., "Folio1!Data 1").
A variable name defined in the Defined Names window (e.g., datasource).
The Row and Column values must be greater than 0.
Example:
DATAENTRY("Folio1!Data 1", 1, 2)
© 1992-2016. ReliaSoft Corporation. ALL RIGHTS RESERVED.
![]() |
E-mail Link |