GEXD Targeting a Cell

The following example demonstrates targeting a cell as the Target Cell/Range/Table value:

Cell A1: identifies the user-defined report name (Open Invoices by Vendor).
Cell A3: the user-assigned literal, indicating what the parameter value represents (Vendor #).
Cell A4: identifies the parameter value needed to execute the GEXD (459).
Cell B4: the user-assigned literal, indicating what type of formula will be used (GEXD Formula).
Cell C4: the location where the GEXD formula will reside.
Cells A6-H6: represents report headers (manually entered).
Cells A7-G7: represents the first row of output data.
Cell H7: identifies the fill down column formula (D7*.09).

Query Name: click the Browse button to select the query (AP Open Invoices Count.EDQ).
Target Worksheet: click the drop-down list to select the worksheet for the output (Sheet7).
Target Type: indicates the format of the output (Cell).
Target Cell: indicates the starting cell of the output data (A7).
Fill Down Column: indicates the number of fill down columns at the end of the output data (1).
Column Headings: indicates whether the GEXD formula output data retrieves headings from the query (not selected in this example, as the headings have previously been typed in the worksheet).
Clear a Range of Cells: indicates the area of output data to be cleared, prior to executing the GEXD formula. As this example contains a fill down column (H7), the clear range starts on the second row of output data (A8:H500), allowing the fill down formula to remain for future executions of the GEXD.
Vendor #: indicates the cell in the worksheet where the query parameter resides (A4).