EssKeepOnly

Description

Performs a Keep Only on the selection range.

Syntax

EssKeepOnly([workbookName]sheetName, range, selection)

Where [workbookName]sheetName is the text name of the workbook and worksheet to which the retrieve occurs.

range is reference to the area of data that is retrieved.

selection is a reference to the members in a dimension which are included in the retrieve. Those members not included from a dimension are excluded from the retrieval.

Example

=EssKeepOnly("[Sample.xls]Sheet1", SAMPLE.XLS!A1:G20, SAMPLE.XLS!B2)

Notes: