EssPivot

Description

Pivots the selected dimension.

Syntax

EssPivot([workbookName]sheetName, range, start, end)

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

range is a reference to the area of data to be retrieved.

start is one cell reference indicating the dimension to be pivoted.

end is one cell reference indicating the destination of the dimension selected by start.

Example

=EssPivot("[Sample.xls]Sheet1", SAMPLE.XLS!A1:G20, SAMPLE.XLS!B4, SAMPLE.XLS!C1)

Notes: